topic Re: Color Formatting in Charts in QlikView

Color Formatting in Charts

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to conditionally format a bar/pie chart, I am using the following formula but it's not working

if([Recommendation State] = 'Closed', Green()) and if if([Recommendation State] = 'Open', Red()), if([Recommendation State] = 'Half Close', Yellow())

Can you please help? What am I getting wrong and where should I put this?

Thanks,

Sunny

Re: Color Formatting in Charts

Anil_Babu_Samineni — Fri, 03 Mar 2017 07:38:31 GMT

Try some thing like below

if([Recommendation State] = 'Closed', Green(), if([Recommendation State] = 'Open', Red(), if([Recommendation State] = 'Half Close', Yellow())

Pick(Match(Only({<[Recommendation State]>}[Recommendation State]), 'Closed', 'Open', 'Half Close'), Green(), Red(), Yellow())

Pick(Match([Recommendation State], 'Closed', 'Open', 'Half Close'), Green(), Red(), Yellow())

Re: Color Formatting in Charts

Anonymous — Fri, 03 Mar 2017 08:26:40 GMT

Thanks a lot Anil