Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist 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!

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

8 Replies
vishsaggi
Champion III
Champion III

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

cbaqir
Specialist II
Specialist II
Author

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
Champion III
Champion III

Check this?

cbaqir
Specialist II
Specialist II
Author

Awesome! You rock! Thanks!

cbaqir
Specialist II
Specialist II
Author

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
Champion III
Champion III

Ok will look into it.

vishsaggi
Champion III
Champion III

Check this?

cbaqir
Specialist II
Specialist II
Author

Thanks!