Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mapratt82
Creator
Creator

Filtering with calculated fields

I have numerous calculated measures for instance "If(Account_Type_Description = ('Demand Deposit'),(Count(distinct{<DDA_External_Tran_Code={'5'}>}DDA_Description_Link)), (Count(distinct{<SAV_External_Tran_Code={'125'}>}SAV_Description_Link)))". The problem is if I filter on DDA_External_Tran_Code say value "9" I'm still getting the count for value "5" in the measure. I have similar issues throughout the app. How do I fix it? If I select "9" I want this calculation to be "0". Please help.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

If(Account_Type_Description = ('Demand Deposit'), Count(DISTINCT {<DDA_External_Tran_Code *= {'5'}>} DDA_Description_Link), Count(DISTINCT {<SAV_External_Tran_Code *= {'125'}>} SAV_Description_Link))

View solution in original post

2 Replies
sunny_talwar

Try this:

If(Account_Type_Description = ('Demand Deposit'), Count(DISTINCT {<DDA_External_Tran_Code *= {'5'}>} DDA_Description_Link), Count(DISTINCT {<SAV_External_Tran_Code *= {'125'}>} SAV_Description_Link))

mapratt82
Creator
Creator
Author

Thanks! It appears that worked! Again thanks so much!