Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ajpabi
Contributor
Contributor
‎2021-03-16 02:42 AM

RAG Values

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)

704 Views
0 Replies