topic Help with SET-analysis - Choose not selected value in QlikView

Help with SET-analysis - Choose not selected value

Tue, 28 Feb 2012 22:31:25 GMT

Hi,

I have an app where a specific period is selected (lets say period 2). But in one of all reports I would like to show period SALES for all periods (1,2,3,4,5,6,7,8,9,10,11,12).

When I use " SUM ({$ <Månad={'03'}>} SALES) " for period 3 it gives me 0. That is because I use $-sign.

But if I try to use " SUM ({1 <Månad={'03'}>} SALES) " I get all Sales (disregarding all other selections) for all years for period 3, but I would only like to have sales for the Year selected.

Please help me with this SET-analysis.

Help with SET-analysis - Choose not selected value

Tue, 28 Feb 2012 22:45:40 GMT

Use:

Period =

blanking the period will ignore that particular selection

Help with SET-analysis - Choose not selected value

CELAMBARASAN — Wed, 29 Feb 2012 05:06:02 GMT

Hi,

Try using this

SUM ({<Månad={'03'},PERIOD=>} SALES)

Here "period=" excludes selection only in that field.

Celambarasan

Re: Help with SET-analysis - Choose not selected value

Wed, 29 Feb 2012 05:36:29 GMT

Hi Tobias,

The equation will be something like this...

SUM ({1 <Månad={'03'},Year='{$(vYear)}'>} SALES)

Set the variable to Year value i.e you have to put a trigger on Year 'select' where you have to set the variable 'vyear' .This equation is valid if you want a chart for a particular year selected and Period=3.

If you want it for year selected but for all the periods then:

sum({1<Year='{$(vYear)}'>} sales)

Let me know if you need any further help.

Regards

Navin.G