Introduction The Pick() function is a QlikView script function. The Pick() function works just the same as the INDEX() function of Excel. The Pick() function can be used with a script and user interface. This function returns the nth expression and also string in the list.The INDEX() returns a value or the value reference from a table. It returns the value in one of the following two forms:
Array form: In this form it returns a value of a specified array of cells.Reference form : In this form it returns the reference of the specified cells.Syntax of Pick() functiondual Pick (position{, Expression})In this syntax the first parameter checks the position of the expression and returns the appropriate expression or string depending on position.Why use Pick() function?
There are the following possible uses of the Pick() function:
The dynamic set analysis expression adds the aggregate function like sum, Avg, Max, Min, Count and so on.Step 1: Open the QlikView applicationIn the first step you need to open the QlikView application then go to File-> New, then this window will be opened.Step 2: Select text objectNow the next step is to select the text object. In the menu bar there is the option Layout. Select:Layout->New sheet object-> Text object.Step 3: New text objectNow in this window we define an expression and click on the Ok button.Now you will see it returns the value of the expression in the first position.Step 4: Change positionIf we want to change the position of an expression then go to the properties of the text object by simply right-clicking on the text object. If we change the position then it gives another value depending on the position.Suppose in this example I change the position to 2 from 1.Now you can see the value has changed. Now the Pick() function returns the value whose position is 2.Step 5: Save fileThe next step is to save our QlikView file.Step 6: Change the color of the text objectIf you want to change the color of the text object then go to the properties of the text object by simply right-clicking on the text object.Now this window will be opened and select the caption tab. Then this window will be opened.The color of the text object exists in two ways.
Active caption: It shows the color of a text object only in active mode.Inactive caption: It shows the color of the text object only inactive mode.Here we set the color for the active caption. Then click on the background color in the active caption.Step 7:Then it shows color areaNow this window will be opened and it shows the color area. Then click on the fixed button.Step 8: If we click on the fixed button then it shows a different color. Select the color and click on the Ok button.Then you will see the color of the text object in active mode. When we select the text object then the color will be shown.If we do not select a text object then no color will be shown.Now follow this process to also apply the color for an inactive caption of the text object.SummaryThe main purpose of this article is to introduce the functionality of the Pick() function and also describe how the pick function works in QlikView.
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: