I have the following conditional formatting issue in qlik sense
I have 5 levels which I have to set conditions for
<.79 (Red)
between .79 and .949 (yellow)
between .95 and 1.2 (Green)
Over 1.2 Blue
See below the arguments that I entered
if((sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, QtyInvoiced))+Sum(If(YM=MaxYM,Qty_Allocated)))
/
sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, Forecast_Cases))<0.75,Red()),
if(((sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, QtyInvoiced))+Sum(If(YM=MaxYM,Qty_Allocated)))
/
sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, Forecast_Cases))>.79) and if((sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, QtyInvoiced))+Sum(If(YM=MaxYM,Qty_Allocated)))
/
sum(If([Fin Year]=[Current Fin Year] and PeriodNo=CurrentPeriodNo, Forecast_Cases))<0.94999, Green()))
I also have to set a blue format for values between .95 to 10
