topic Re: Coloring the Qliksense Stacked chart based on the Legend in App Development

Coloring the Qliksense Stacked chart based on the Legend

TamilSelvi — Fri, 15 Nov 2024 20:59:25 GMT

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.

Re: Coloring the Qliksense Stacked chart based on the Legend

NitinK7 — Thu, 25 Apr 2024 07:25:41 GMT

Hi @TamilSelvi ,

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

Re: Coloring the Qliksense Stacked chart based on the Legend

TamilSelvi — Thu, 25 Apr 2024 10:29:07 GMT

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.

Re: Coloring the Qliksense Stacked chart based on the Legend

NitinK7 — Thu, 25 Apr 2024 13:07:55 GMT

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

Re: Coloring the Qliksense Stacked chart based on the Legend

TamilSelvi — Fri, 26 Apr 2024 10:21:50 GMT

I selected as you said,

but its not working still

Re: Coloring the Qliksense Stacked chart based on the Legend

TamilSelvi — Mon, 29 Apr 2024 06:28:56 GMT

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

Re: Coloring the Qliksense Stacked chart based on the Legend

TamilSelvi — Tue, 07 May 2024 11:30:06 GMT

Is there any solution for this