Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables in expression


Hi All,

I'm going to use variable for my Field values.

count({<P_Name='Z_Territory'}>}DISTINCT PRIOR_DATA) this expression works fine. I want to use Variable for the values like 'Z_Territory'.

count({<P_Name="vZTerritory"}>}DISTINCT PRIOR_DATA) but this is not giving correct result.I'm doing some silly mistake here.???

2 Replies
fkeuroglian
Partner - Master
Partner - Master

Hi,

The only thing you have to do is change the expresion , and of course create the variable

exmple:


count({<P_Name=$(VARIABLE)}>}DISTINCT PRIOR_DATA) this expression works fine. I want to use Variable for the values like 'Z_Territory'.

if you want to obtain the value of the variable you have to put in $(variable), not " "

good luck

Fernando

Not applicable
Author

Never mind.Got it.

count({<P_Name={$(vZTerritory)}>}DISTINCT PRIOR_DATA)