topic Re: Ignore Filter Settings in QlikView

Ignore Filter Settings

Mon, 25 Aug 2014 08:29:09 GMT

Hello

I wan't to ignore one filter which I want to set on a certain value.

So I got:

sum(if(Year=$(vLastYear) AND PeriodID = ($(vActualPeriodID)-12) AND Stage = ('S')))/1000000

And I want just to ignore the filter settings for Year but keep it on vLastYear.

I tried with sum({1<Year=E(Year), PeriodID <= {($(vActualPeriodID)-12)}, Stage ={('S')}>}) but that didn't work

Anyone got a idea how to this working

Thanks

Peter

Re: Ignore Filter Settings

jagan — Mon, 25 Aug 2014 08:38:37 GMT

Hi,

Try like this

sum({1<Year={'$(vLastYear)'}, PeriodID = {'<=($(vActualPeriodID)-12)'}, Stage ={'S'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

Re: Ignore Filter Settings

Mon, 25 Aug 2014 08:49:25 GMT

Guess it would be as below

sum({1<Year=, PeriodID = {'<=($(vActualPeriodID)-12)'}, Stage ={'S'}>} MeasureName)

Please provide more information about this.

Thanks,

Sri

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:12:13 GMT

No,

this gives always 0,0 as value, independet from all filter settings

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:13:37 GMT

No dosn't work,

it gives me 0,0 as value, independent from all filter settings

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:15:39 GMT

Okay the problem is the periodID, without this it works

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:16:15 GMT

Okay the problem is the period id, without it it works

Re: Ignore Filter Settings

jagan — Mon, 25 Aug 2014 09:20:38 GMT

Hi,

What is the format of your Period id? If you are ok without it then close this thread.

Regards,

Jagan.

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:23:56 GMT

But this filter settings ignores all other settings also, but all others then these three shall have an effect

Re: Ignore Filter Settings

Mon, 25 Aug 2014 09:24:15 GMT

But this filter settings ignores all other settings also, but all others then these three shall have an effect

Re: Ignore Filter Settings

jagan — Mon, 25 Aug 2014 09:26:21 GMT

Hi,

If you want to consider the other filters then remove 1 in set analysis like below

sum({<Year={'$(vLastYear)'}, Stage ={'S'}>} MeasureName)

Regards,

Jagan.

Re: Ignore Filter Settings

Mon, 25 Aug 2014 12:51:11 GMT

Works now when the expression is in a variable