topic Re: Set Analysis - field value greater than selected in QlikView

Set Analysis - field value greater than selected

byrnel0586 — Wed, 22 May 2019 14:29:21 GMT

Hi all!

I am needing some help to create a calculation that counts the number of claims that are "Approved" at a later date than the Reporting Cycle that is selected. For example, if I have January 2019 selected, I only want to count the approved claims from February-May 2019.

I have something like this but I knew it wouldn't work...

=count({<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_REPORT_CYCLE]={"> Only([DETRMN_REPORT_CYCLE])"}>}[DETRMN_AUTH_CLAIM_NBR])

Any help is much appreciated!!

Re: Set Analysis - field value greater than selected

Navya — Wed, 22 May 2019 15:23:51 GMT

Hi ,

Can you try this expression.

count({$<[DETRMN_DISPOSITION]={'Approved'},[DETRMN_REPORT_CYCLE]={">$(=GETFIELDSELECTIONS([DETRMN_REPORT_CYCLE]))<=$(=max([DETRMN_REPORT_CYCLE]))"}>} [DETRMN_AUTH_CLAIM_NBR])

This should work if the DETRMN_REPORT_CYCLE is brought from a calendar measure,if its a text then it cannot calculate > and < because that works only for numeric fileds.

Make sure that field is numeric or calendar measure.

Thanks,

Navya

Re: Set Analysis - field value greater than selected

byrnel0586 — Wed, 22 May 2019 17:44:52 GMT

Thank you! Those fields were being recognized as text.