Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Aggregate combined with condition

I need to create a formula to color code red for any 2 months below threshold within 4 rolling month period.  The value that needs to be verified for each month is % on time:  sum(on time)/sum(total).  Below is a simplified dataset.  Example: if the user selects period 2019-05, the formula must check the % on time for may, April, March and February.  If 2 of those months have a % on time below a certain threshold I need to color the background of a column red. 

The output table is grouped by name and period and has the value % on time but only the selected period is displayed (while the calculation must check the max of selected period and previous 3 months)

Namemonthtotal on time
A2019-0111
A2019-0211
A2019-0110
A2019-0111
A2019-0411
A2019-0611
B2019-0110
B2019-0211
B2019-0110
B2019-0311
B2019-0410
B2019-0611
Labels (3)
0 Replies