calculating counts using set analysis

ManiSK — Fri, 15 May 2020 17:05:45 GMT

Can someone help me on below query?

i want to calculate the counts with below conditions

less than GRANT_DATE which i'm selecting + INELIGIBLE = N + RISK =[HIGH]

=count({$<GRANT_DATE ={"<=$(=GRANT_DATE)"}>+1<INELIGIBLE={'N'}>+1<RISK={'[HIGH]'}>}ENTITLEMENT_UNIQUE_ID)

And also wanted to know whether its possible to allow the user to update GRANT_DATE in the variable in dashboard and calculate the counts?

Thanks,

Re: calculating counts using set analysis

rubenmarin — Sat, 16 May 2020 14:42:18 GMT

Hi, the '+' between sets (defined by < and >) will be considered as an 'OR', if you want an 'AND' * can be used, but in this case maybe you only need to do a single set with fields separated by commas:

=count({$<GRANT_DATE ={"<=$(=GRANT_DATE)"}, INELIGIBLE={'N'}, RISK={'[HIGH]'}>}ENTITLEMENT_UNIQUE_ID)

topic Re: calculating counts using set analysis in QlikView

calculating counts using set analysis

Re: calculating counts using set analysis