topic Re: Set analysis for projects with sales over 0 in QlikView

Set analysis for projects with sales over 0

enfodavid — Wed, 28 Mar 2018 14:01:43 GMT

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

Re: Set analysis for projects with sales over 0

Chanty4u — Wed, 28 Mar 2018 14:05:16 GMT

try this

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

Re: Set analysis for projects with sales over 0

enfodavid — Wed, 28 Mar 2018 14:07:15 GMT

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

Re: Set analysis for projects with sales over 0

Chanty4u — Wed, 28 Mar 2018 14:12:56 GMT

may b

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

Re: Set analysis for projects with sales over 0

enfodavid — Wed, 28 Mar 2018 14:20:54 GMT

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

Re: Set analysis for projects with sales over 0

Chanty4u — Wed, 28 Mar 2018 14:22:11 GMT

Cool