Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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