Introduction
The Match() function can be used to compare strings, fields and variables using the string expression. The result of comparison is always an integer that shows the match expression. In the Match() function if no value is returned then the result would be 0. If an integer value is returned then the result would be 1. This function can used with the expression and it cannot be used with a chart, list box or text box. The Match() function will be used for a specified item in an array and then return the item in a specified position in a specified order. In the Match() the comparison is case sensitive.
Where to use Match() function
- The Match() function can be used in a QlikView application for the "Switch Case" statement.
- It can be also used as a substitution in an If statement.
- It can be used in a Load Script as an In statement.
- It can be used to find a match without using the duplicate value.
Step 3: In the Main window, right-click anywhere and then the select the "Select Fields"
How to use the Match() function in QlikView
Use the following procedure to to use the Match() function in QlikView.
Step 1: Open the QlikView application, then go to- "File" "->" New. The following menu will be shown:
![After clicking New option]()
Step 2: Then go to the main window and the following window will be opened.
![Main Window]()
Step 3: In the main window, right-click anywhere and then select "Select Fields..." as in the following:
![Right Click on main window]()
Step 4: After right-clicking on the "Select Fields", select the Excel file and the proper upload for the field.
![Upload a field]()
Then right-click on the window and then select the "New Sheet Object".
![After uploading file right click on main]()
Then select the "Text Object". The window will look like the following:
![Right Click on New sheet object]()
Step 5: After right-clicking on "Text Object" the following window will be opened.
![After right click on text object]()
Step 6: Write the code in the Text box, then:
![Write the code in text box]()
Step 7: After writing the code this window will be opened:
![After writing the code]()
This is the final window that shows the specified position of the manager in the specified order.
Summary
These basic steps show how the Match() function will work when uploading a field and you want to determine the position of each and every item stored in a field.