topic Re: Complex Counts in QlikView

Complex Counts

cbaqir — Fri, 21 Jul 2017 17:03:22 GMT

I am struggling with showing some totals in the attached example.

I want to show Total Defects in Queue (CUR_GOV_PROCESS_QUEUE) based on the logic within the chart and Total Defects in Queue beyond the threshold.

Current chart logic:

If the same defect was in the queue more than once, it should only take the most recent date to calculate # days:

= Aggr(IF(Rank(Date(if(match(CUR_GOV_PROCESS_QUEUE,'Solution Design Group')>0,GPQ2_START_DATE,null())), 0) = 1, GPQ2_START_DATE), DEFECT_ID, GPQ2_START_DATE)

In my example, the queue is Solution Design Group and the threshold is 120 days. I would expect to see 6 total defects and 2 defects outside of the threshold.

Can someone please help me?

TIA!

Re: Complex Counts

vishsaggi — Fri, 21 Jul 2017 17:15:03 GMT

You want to see 2 in your text box ? Is this what you are looking for?

Re: Complex Counts

cbaqir — Fri, 21 Jul 2017 17:16:14 GMT

In my example, the queue is Solution Design Group and the threshold is 120 days. I would expect to see 6 total defects and 2 defects outside of the threshold.

Re: Complex Counts

vishsaggi — Fri, 21 Jul 2017 17:23:58 GMT

Check this?

Re: Complex Counts

cbaqir — Fri, 21 Jul 2017 17:30:30 GMT

Awesome! You rock! Thanks!

Re: Complex Counts

cbaqir — Fri, 21 Jul 2017 19:19:00 GMT

Something isn't quite right. See attached.

The numbers look right for the Solution Design Group - the solution you provided. However, when I try to apply the same expressions for the First chart, 'Regional Clinical Informatics', the numbers clearly aren't right as there are 114 defects beyond the threshold, but it shows 2.

Re: Complex Counts

vishsaggi — Fri, 21 Jul 2017 19:44:08 GMT

Ok will look into it.

Re: Complex Counts

vishsaggi — Fri, 21 Jul 2017 20:46:48 GMT

Check this?

Re: Complex Counts

cbaqir — Fri, 21 Jul 2017 20:50:36 GMT

Thanks!