Need help on Pie chart color

praveensprabhu — Sat, 16 Nov 2024 17:44:04 GMT

Hi,

I have an issue with Pie chart color based on a condition.

I have a Pie chart that should not be affected by any filter condition. so I have used set analysis. but when I select any filter value, the pie chart shows entire data but the colors are highlighted only for the selected filter value, rest of the slices in pie chart are shown in white color and the legends color change to black.

please see below screenshots -

Chart Properties -

I have used the BG color on Expressions. This is the expression I am using -

=if(Statuss = 'Closed',green(),if(Statuss = 'Inactive/Archived',LightGray(),if(Statuss = 'On-Going',Yellow())))

Let me know where I am doing wrong. I tried by keeping this expression in BG color property of dimension. It isn't working there either.

Thanks,

Praveen Prabhu

Re: Need help on Pie chart color

Kushal_Chawda — Mon, 07 Dec 2020 16:24:32 GMT

@praveensprabhu try below expression in BG color

=if(only({1}Statuss) = 'Closed',green(),if(only({1}Statuss) = 'Inactive/Archived',LightGray(),if(only({1}Statuss) = 'On-Going',Yellow())))

Re: Need help on Pie chart color

praveensprabhu — Tue, 08 Dec 2020 06:13:25 GMT

Thank you....This expression worked.

topic Re: Need help on Pie chart color in QlikView

Need help on Pie chart color

Re: Need help on Pie chart color

Re: Need help on Pie chart color