topic Re: additional condition on Variable in QlikView

additional condition on Variable

Thu, 17 Mar 2016 12:54:10 GMT

Hi,

I have a variable 'Sales' (with a quite complex formula behind it) that I use everywhere in my app.

On 1 chart I want an additional 'year = 2015' to be applied, like you can do in set analysis.

But I have no clue how to use a Variable inside a Set Analysis formula.

Conceptually it is like this:

Sum ({<year={2015}>}$(Sales))

But I don't get it to work...

Any help?

Re: additional condition on Variable

sunny_talwar — Thu, 17 Mar 2016 15:46:15 GMT

If Sales is something like this -> Sum(Sales), then what you are trying to do won't work. I would suggest to use the expression, instead of variable in cases such as these.

Re: additional condition on Variable

Gysbert_Wassenaar — Thu, 17 Mar 2016 16:37:13 GMT

Change your variable so that it accepts a parameter. For example if a variable vSales is defined as sum(Sales) then change it to sum($1 Sales). You can then use it in an expression like this: =$(vSales({<Year={2015}>}))