Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

Re: Set analysis for projects with sales over 0

may b

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

View solution in original post

5 Replies
Highlighted
Champion III
Champion III

Re: Set analysis for projects with sales over 0

try this

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

Highlighted
Partner
Partner

Re: Set analysis for projects with sales over 0

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

Highlighted
Champion III
Champion III

Re: Set analysis for projects with sales over 0

may b

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

View solution in original post

Highlighted
Partner
Partner

Re: Set analysis for projects with sales over 0

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

Highlighted
Champion III
Champion III

Re: Set analysis for projects with sales over 0

Cool