Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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)
5 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?