Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreasMoller
Contributor III
Contributor III

Filtering

Hello,

I got some problems with filtering and i hope someone can help me.

I have 1 table with 2 fields/measures with differents sources.
"Total Orders" with source "Order".
"Number of Claims" with source "Claim".

I also have these 2 fields that i filter on.
"Date" with both sources.
"Claim Reason" with source "Claim".

When i filter on "Date" it filtering on both measuers, which is correct.
But when i filter on "Claim Reason", then "Number of Claims" filters correct but "Total Orders" gets to 0 because its the "Wrong" source.
How can I make "Total Orders" to not be filtered when i filter on something in field "Claim Reason"?

Labels (1)
1 Solution

Accepted Solutions
ogster1974
Partner - Master II
Partner - Master II

You can ignore certain filters in your set analaysis.

e.g. Count({<[Claim Reason]=>} OrderId)

 

View solution in original post

2 Replies
ogster1974
Partner - Master II
Partner - Master II

You can ignore certain filters in your set analaysis.

e.g. Count({<[Claim Reason]=>} OrderId)

 

AndreasMoller
Contributor III
Contributor III
Author

Thank you, it helped!