Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi! I'm new to Qlik. Currently having a challenge in including amber to the current set analysis in our data. Anyone who knows how to tweak this set analysis to include amber on the formula?
Red: <70%
Amber: 70-79%
Green: >=80%
SET ANALYSIS:
Pick(Match(GetSelectedCount(Entity)>0,-1,0),Pick(match($(Learning Delivery %Planned - Entity) <$(Learning Delivery %Planned Target - Entity),-1,0),cRed,cGreen),Pick(match($(Learning Delivery %Planned) <$(Learning Delivery %Planned Target),-1,0),cRed,cGreen)
