Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cbaqirdhds
Contributor II

Complex Counts

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!

Tags (3)
1 Solution

Accepted Solutions
vishsaggi
Esteemed Contributor III

Re: Complex Counts

Check this?

8 Replies
vishsaggi
Esteemed Contributor III

Re: Complex Counts

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

cbaqirdhds
Contributor II

Re: Complex Counts

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.

vishsaggi
Esteemed Contributor III

Re: Complex Counts

Check this?

cbaqirdhds
Contributor II

Re: Complex Counts

Awesome! You rock! Thanks!

cbaqirdhds
Contributor II

Re: Complex Counts

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.

vishsaggi
Esteemed Contributor III

Re: Complex Counts

Ok will look into it.

vishsaggi
Esteemed Contributor III

Re: Complex Counts

Check this?

cbaqirdhds
Contributor II

Re: Complex Counts

Thanks!

Community Browser