Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Set analysis for projects with sales over 0

Is it possible to make a set analysis checking for sales of a project that exceed zero with a variable?

Sum({<Project = {"$('vProject')"}>}Sales)

Where the variable vProject is set to 'Sales > 0' but can be switched for 'Sales <=0' e.g.

Or am I going about this all wrong? I'm using a variable to be able to switch this out all through the app with a simple change of a variable (read "press of a button")

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

may b

Sum({<Project = {"=sum(sales)>0"}>}Sales)

View solution in original post

5 Replies
Highlighted
Champion III
Champion III

try this

Sum({<Project = {"=$(=vProject)"}>}Sales)

Highlighted
Partner
Partner

Doesn't seem to work, maybe the variable should be more than just 'Sales > 0' ?

Highlighted
Champion III
Champion III

may b

Sum({<Project = {"=sum(sales)>0"}>}Sales)

View solution in original post

Highlighted
Partner
Partner

Yes, that works so it must be me using a variable like a tool :^)

Highlighted
Champion III
Champion III

Cool