How to let If Statement ignore a filter?

[mrichman]

Hi All,

An additional question to my other case: 

https://community.qlik.com/t5/New-to-QlikView/How-to-let-a-Set-Analysis-and-AGGR-combi-ignore-a-filt...

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 · Accepted solution]

May be try this

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

[mrichman]

It worked! Thanks Sunny!

[Shubham_Deshmukh]

Hi @sunny_talwar Sunny,

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,