topic Aggregate combined with condition in Qlik Sense Advanced Authoring
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/Aggregate-combined-with-condition/m-p/1639380#M960
<P><SPAN>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. </SPAN></P><P>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)</P><TABLE><TBODY><TR><TD>Name</TD><TD>month</TD><TD>total </TD><TD>on time</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-02</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-04</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-06</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-02</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-03</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-04</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-06</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE>Thu, 24 Oct 2019 09:30:42 GMTgeertdeman2019-10-24T09:30:42ZAggregate combined with condition
https://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/Aggregate-combined-with-condition/m-p/1639380#M960
<P><SPAN>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. </SPAN></P><P>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)</P><TABLE><TBODY><TR><TD>Name</TD><TD>month</TD><TD>total </TD><TD>on time</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-02</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>A</TD><TD>2019-01</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-04</TD><TD>1</TD><TD>1</TD></TR><TR><TD>A</TD><TD>2019-06</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-02</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-01</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-03</TD><TD>1</TD><TD>1</TD></TR><TR><TD>B</TD><TD>2019-04</TD><TD>1</TD><TD>0</TD></TR><TR><TD>B</TD><TD>2019-06</TD><TD>1</TD><TD>1</TD></TR></TBODY></TABLE>Thu, 24 Oct 2019 09:30:42 GMThttps://community.qlik.com/t5/Qlik-Sense-Advanced-Authoring/Aggregate-combined-with-condition/m-p/1639380#M960geertdeman2019-10-24T09:30:42Z