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)