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: 
enfodavid
Partner - Contributor III
Partner - Contributor III

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
Chanty4u
MVP
MVP

may b

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

View solution in original post

5 Replies
Chanty4u
MVP
MVP

try this

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

enfodavid
Partner - Contributor III
Partner - Contributor III
Author

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

Chanty4u
MVP
MVP

may b

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

enfodavid
Partner - Contributor III
Partner - Contributor III
Author

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

Chanty4u
MVP
MVP

Cool