Qlik Sense - ignoring SET expressions

[#1]

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,

[rubenmarin]

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

[#3]

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 · Accepted solution]

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.