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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ColtE8
Contributor III
Contributor III

Color Coding

I have a bar graph with multiple rows. The rows show a certain percentage of completion. Within these percentage of completions are different status for each row. Something could be 100% complete but not labeled "Validated" and the next one down could be 100% complete AND labeled "Validated". I need the graph to color code these different. The criteria could be something like this:

     100% and Status is Validated: Green

     100% but Status is NOT Validated: Navy

     Status is Implemented: Orange

     Status is Developed: Yellow

So I have this right now:

if([Status] = 'Validated', 'green', if([Status] = 'Developed', 'yellow', 'navy'))

This isn't even working to begin with and I don't know where else to take this. Please help!

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/
Labels (6)
3 Replies
brunobertels
Master
Master

hi 

may be this 

if( YourMesure='100%' AND [Status] = 'Validated', green() , 

if(YourMesure='100%' AND [Status] =- 'Validated', lightblue(), 

if([Status] = 'Implemented' , orange , 

if([Status] = 'Developed' , Yellow )))) 

 

ColtE8
Contributor III
Contributor III
Author

Ya that's not really working either 😕

Right now the best I can get is:

if([Measure] > .8, Green(), if([Measure] < .3, Yellow(), 'Navy'))

So now anything above 80% is green, between 30% and 80% is Navy, lower than 30% is yellow. It's not the fix to the issue though. I still would like the color to change if that actual status is different.

Thanks,

Colton Esman
https://www.linkedin.com/in/colton-esman/
brunobertels
Master
Master

hi 

ok what about to aggr your color coding by Status ? 

aggr(

if([Measure] > .8, Green(), if([Measure] < .3, Yellow(), 'Navy')),

Status )