Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

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?


Labels (1)
1 Reply
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.