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:

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.