topic Re: Set analysis with a variable in QlikView

Set analysis with a variable

Mon, 18 Jun 2012 09:59:12 GMT

Hi all

Using set analysis, basic example below:

=sum({$ < Year={2007} >} Sales)

However, what I would like to do is instead of having the 2007 as an actual value I would like it to be based
on the value of a variable say called var_year.

I have tried:

=sum({$ < Year={var_year} >} Sales)

and I have tried:

=sum({$ < Year= var_year >} Sales)

But no luck. Any idea on how I can get this to work?

Thanks

Revlin

Re: Set analysis with a variable

jagan — Mon, 18 Jun 2012 11:15:52 GMT

Hi,

Try like this

=sum({$ < Year={'=$(=var_year)'} >} Sales)

Regards,

jagan.

Re: Set analysis with a variable

Mon, 18 Jun 2012 11:33:25 GMT

Hi Jagan

Just tried but no luck.

Re: Set analysis with a variable

Miguel_Angel_Baeyens — Mon, 18 Jun 2012 11:36:10 GMT

Hi Revlin,

If the variable as a numeric value like 2009 or 2010 then the following should do

=Sum({< Year = {$(var_year)} >} Sales)

Hope that helps.

Miguel

Re: Set analysis with a variable

Mon, 18 Jun 2012 11:38:09 GMT

Try this:

Define your variable,

vSales=sum({$ < Year={$1} >} Sales)

Then use it where you need it,

$(vSales('2007'))

Re: Set analysis with a variable

Mon, 18 Jun 2012 11:39:07 GMT

Perfect - that works!

Much appreciated.

Regards

Revlin