topic Re: Variables in expression in QlikView

Variables in expression

Tue, 18 Feb 2014 10:35:39 GMT

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.???

fkeuroglian — Tue, 18 Feb 2014 10:46:38 GMT

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

Tue, 18 Feb 2014 10:49:03 GMT

Never mind.Got it.

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