Skip to main content Resources | Qlik Greenway
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
canmarroig
Partner
Partner
‎2019-02-06 09:46 AM

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)
Labels
253 Views
0 Likes
1 Reply
pradosh_thakur
Master II
Master II
‎2019-02-06 09:51 AM

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.
250 Views
0 Likes
Community Browser