Qlik Community

Qlik Sense Advanced Authoring

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

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
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