Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thanks you Piet Hein very much Van der Stigchel, that was eactly want i want !!!