Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
mrichman
Creator II
Creator II

How to let If Statement ignore a filter?

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! 

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

May be try this

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

View solution in original post

3 Replies
sunny_talwar

May be try this

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

View solution in original post

mrichman
Creator II
Creator II
Author

It worked! Thanks Sunny!
Shubham_Deshmukh
Specialist
Specialist

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,