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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
TamilSelvi
Contributor II
Contributor II

Coloring the Qliksense Stacked chart based on the Legend

I need to use the color for stacked chart based on the legend dimension value.

For example, if I show the sum value for month and Status in the stacked bar chart , the color of the bar should be based on the status value.

 

I used the below expression in the Appearance >> Color and Legend >> Use custom colors

 

=pick(Match(ErrorStatus,'Success','Service Unavailable','Bad Gateway'),'#009845','#004080','#F20000')

 

but its not working properly. If I made the selections in the status then the bar is appearing with the corresponding color but if there is no selection then the bar itself is not showing.

 

But if I scroll over the chart area the tooltip is appearing as normal.

Labels (1)
6 Replies
NitinK7
Specialist
Specialist

Hi @TamilSelvi ,

Create master dimension for status and provide color over there and and select colors by dimension 

NitinK7_0-1714029850387.png

NitinK7_1-1714029919772.png

 

TamilSelvi
Contributor II
Contributor II
Author

Hi NitinK7

Thanks for the Response.

 

But I am only able to select the by dimension option only. I am not able to get the option to select the dimension.

 

I am getting the color pallet immediately below the by dimension option.

TamilSelvi_0-1714040897167.png

 

 

NitinK7
Specialist
Specialist

First do off use color scheme option then you can able to see

NitinK7_0-1714050440932.png

 

TamilSelvi
Contributor II
Contributor II
Author

I selected as you said,

but its not working still

 

TamilSelvi_0-1714126899247.png

 

TamilSelvi
Contributor II
Contributor II
Author

Its not working stll . Is there any solution for this?

TamilSelvi
Contributor II
Contributor II
Author

Is there any solution for this