Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mapratt82
Not applicable

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
Not applicable

Re: Filtering with calculated fields

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))

2 Replies
sunny_talwar
Not applicable

Re: Filtering with calculated fields

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
Not applicable

Re: Filtering with calculated fields

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