Display one field, but use another for any logic/selections

[sk88024]

Hello,

I have two Fields mapped as below:

Period	Num
P1	0
P2	1
P3	2
P4	3

In Filter object, I want Period to appear, but any selection should be based on the Num.

For e.g.: If I select P1, Qlik should recognize it as 0, not P1.

Any idea how to achieve this please?

[Ahidhar]

something like this ?

[steeefan]

Try creating a field of type Dual():

Dual(Period,Num) AS PeriodNum

Dual() combines a number and a string into a single record, such that the number representation of the record can be used for sorting and calculation purposes, while the string value can be used for display purposes.

[rwunderlich]

@steeefan suggestion is good for this case.  See this post for more suggestions on how you may control what is displayed vs what is selected. 

https://qlikviewcookbook.com/2016/01/scoping-selections-with-aggr/

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com