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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use of variable in set analysis

Hello everybody,

Today i got a problem with qlik,

I created i variable $(POC) that can take to value :'Yes' or 'No'

now i'm tryng use this variable to count a flied called  'Poche' when $(POC) = 'Yes'

so it'll count the number of 'poche' when $(POC)='Yes'.

my syntax is like that : count({<$(POC)={'Yes'}>} [Poche])

and it dosent work ! Somebody have a solution please ?

Thanx you

11 Replies
stigchel
Partner - Master
Partner - Master

If $(POC) is an expression, can you try with

Count({<Poche={"=$(POC)='Qui'"}>} Poche)


With the assumption that the = sign is not included  in your variable POC. Also $ sign expansion is only evaluated at chart level, so not per row level of the dimension.

Not applicable
Author

Thanks you Piet Hein very much Van der Stigchel, that was eactly want i want  !!!