topic One color by Product in QlikView

One color by Product

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

Hi Qlikers,

How can i define one color by product in the Grpahic joined ? (blue for product a , red for b ; etc ...)

tkanks 4 your help !

Max.

Anonymous — Fri, 21 Oct 2016 10:24:22 GMT

Hi,

please check the below link. It might help you,

Regards,

Leni Balakrishnan

yasmeenk — Fri, 21 Oct 2016 10:27:41 GMT

Like this?

sergio0592 — Fri, 21 Oct 2016 10:34:01 GMT

You can try this. But if you have a lot of conditions/colors, avoid if.

Anil_Babu_Samineni — Fri, 21 Oct 2016 10:36:24 GMT

I Don't have License

How can i define one color by product in the Grpahic joined ? (blue for product a , red for b ; etc ...)

If(Product = 'A', Blue(), If(Product = 'B', Red(), ....)

sergio0592 — Fri, 21 Oct 2016 10:44:38 GMT

And for avoid nested if:

=pick(match(product,'a','b','c','d'),red(),blue(),green(),black())

susovan — Fri, 21 Oct 2016 10:47:04 GMT

You can try this process,

first of all tick the multicolored option than set the colour priority of 'color 1-6' column according to your requirement.

Please find the below attached image for the ready reference.

Fri, 21 Oct 2016 10:57:31 GMT

Select both check boxes i.e. Multicolored and Persistent colors both.

It will be persistent to each value of your dimension.

Thanks.

maxime66 — Fri, 21 Oct 2016 11:23:57 GMT

Thanks everyone,