Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore Filter Settings

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

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

11 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

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


Hope this helps you.


Regards,

Jagan.

Not applicable
Author

Guess it would be as below


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


Please provide more information about this.


Thanks,

Sri

Not applicable
Author

No,

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

Not applicable
Author

No dosn't work,

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

Not applicable
Author

Okay the problem is the periodID, without this it works

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

Not applicable
Author

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

Not applicable
Author

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