topic Re: How to let If Statement ignore a filter? in QlikView

How to let If Statement ignore a filter?

mrichman — Sat, 16 Nov 2024 04:55:11 GMT

Hi All,

An additional question to my other case:

I would like to ignore Year if the type is 1.

What I have done but not working 😞

if(Type='1',Count({<Year=>} Distinct Clients),Count(Clients))

Do you guys have any idea?

Thanks in advance!

sunny_talwar — Thu, 20 Dec 2018 13:26:33 GMT

May be try this

If(Only({<Year>} Type) = '1', Count({<Year>} DISTINCT Clients), Count(Clients))

mrichman — Thu, 20 Dec 2018 13:59:22 GMT

It worked! Thanks Sunny!

Shubham_Deshmukh — Wed, 26 Feb 2020 05:31:48 GMT

I want to ignore filter in ELSE part of exp, the filter which I want to Ignore is Always Single Selection enabled. How to make it?

Shubham,