Match() Function In QlikView

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:



Step 2: Then go to the main window and the following window will be opened.



Step 3: In the main window, right-click anywhere and then select "Select Fields..." as in the following:



Step 4: After right-clicking on the "Select Fields", select the Excel file and the proper upload for the field.



Then right-click on the window and then select the "New Sheet Object".

Then select the "Text Object". The window will look like the following:



Step 5: After right-clicking on "Text Object" the following window will be opened.



Step 6: Write the code in the Text box, then:



Step 7: After writing the code this window will be opened:

 

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.