topic Show different colors for dimensions in bar chart. in QlikView

Show different colors for dimensions in bar chart.

fionna51 — Mon, 18 Jul 2016 16:01:37 GMT

Hi,

In my app, one login user may contain multiple organizations, my bar chart x-axis is organization and Y-axis is Rate. We have 100 organizations (Organization ID), when one user log in, he might have 4 (Entity ID) of them. I want to show these 4 organizations different colors from other 96.

I am using below statement in Rate expression background color which is working fine if user only have one organization. When user contains multiple organization, all 100 are showing same color. Please advise.

if( [Organization ID]=[Entity ID],$(cDarkGreen),$(cLightGreen))

Re: Show different colors for dimensions in bar chart.

settu_periasamy — Mon, 18 Jul 2016 19:37:42 GMT

May be try like

=if(WildMatch([Organization ID],Concat(Distinct Chr(39)&[Entity ID]&chr(39),',')),$(cDarkGreen),$(cLightGreen))

Re: Show different colors for dimensions in bar chart.

fionna51 — Tue, 19 Jul 2016 15:53:26 GMT

Hi,

Thanks for your help, I got your idea. But seems no luck, this is not working. Even only one Entity this didn't work yet.