Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner - Creator
Partner - Creator

Syntax on set analysis instead of if condition

I need to calculate a KPI only if a dimension is greater than a number set in a variable

Sum({<Dimension={"=COUNT(Dimension)>$(vNumber)"}>} XXXXXX)

but it doesn't work, i don't want to use if condition for performance troubles, is it possible?

Tks

Labels (1)
1 Reply
pradosh_thakur
Master II
Master II

generally it should be
Sum({<a unique field other than dimension ={"=COUNT(Dimension)>$(vNumber)"}>} XXXXXX)

but anyways if you replace the variable with a number , let's say 5 , does it work?
Learning never stops.