Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
enfodavid
New 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

Tags (2)
1 Solution

Accepted Solutions
Chanty4u
Esteemed Contributor III

Re: Set analysis for projects with sales over 0

may b

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

5 Replies
Chanty4u
Esteemed Contributor III

Re: Set analysis for projects with sales over 0

try this

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

enfodavid
New Contributor III

Re: Set analysis for projects with sales over 0

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

Chanty4u
Esteemed Contributor III

Re: Set analysis for projects with sales over 0

may b

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

enfodavid
New Contributor III

Re: Set analysis for projects with sales over 0

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

Chanty4u
Esteemed Contributor III

Re: Set analysis for projects with sales over 0

Cool