Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlik Sense - ignoring SET expressions

Hello,

I am using Qlik Sense 1.1

I have a measure expression in straight table as below to count only those claims that are approved

count({$<[CLAIMSTATUS_DESC]={'Approval'}>}distinct CLAIM_ID)

However the table is instead calculated for All claim status ignoring the SET criteria above.   Is there anything obvious I am missing?

Appreciate your help!

Thanks,

1 Solution

Accepted Solutions
rubenmarin

Hi, please check this link: https://community.qlik.com/docs/DOC-7323/version/8

If it's because of direct query you'll need to change your expression avoiding set analysis, maybe adding flags to the records in script can help to obtain the desired results.

View solution in original post

3 Replies
rubenmarin

Hi, please double-check field name [CLAIMSTATUS_DESC] and if that field really has an 'Approval' value with data.

Not applicable
Author

Hi Ruben,

I've verified the column name as well as the value - no issues there.

Also the expression builder does not throw up error.

One item I forgot to mention.  I am using Direct Query instead of cached tables in my sense app.  I am not sure if this makes any difference

Thanks

rubenmarin

Hi, please check this link: https://community.qlik.com/docs/DOC-7323/version/8

If it's because of direct query you'll need to change your expression avoiding set analysis, maybe adding flags to the records in script can help to obtain the desired results.