Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Exlude a specific filter selection from affecting an Expression

All,

I know this is a simple thing to do, but how do I alter the expression below to ignore any selections made by the "IM Missed SLA" filter?

=count(DISTINCT{<[IM Missed SLA]={'No'},[IM Resolved Flag]={1},[Date Type ID]={2}>}[Ticket ID])/
count(DISTINCT {<[IM Resolved Flag]={1},[Date Type ID]={2}>}[Ticket ID]
)

3 Replies
sunny_talwar

May be this:

=Count(DISTINCT{<[IM Missed SLA] = {'No'}, [IM Resolved Flag] = {1}, [Date Type ID] = {2}>} [Ticket ID])/
Count(DISTINCT {<[IM Missed SLA], [IM Resolved Flag] = {1}, [Date Type ID] = {2}>} [Ticket ID])

brf10043
Creator
Creator
Author

Thanks Sunny!  That works perfectly!

sunny_talwar

Awesome