Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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