topic Re: DYNAMIC COLORS in QlikView

DYNAMIC COLORS

christian77 — Fri, 27 Jul 2012 07:49:56 GMT

Hi:

I want to set colors dynamically according to my
product. Each product has its color.

Does anybody know how to do that?

Example attached.

Re: DYNAMIC COLORS

giakoum — Fri, 27 Jul 2012 08:04:21 GMT

see attached

Re: DYNAMIC COLORS

christian77 — Fri, 27 Jul 2012 09:04:32 GMT

Hi:

Thanks. Could we do it with only one field?

Anyway is good.

Re: DYNAMIC COLORS

giakoum — Fri, 27 Jul 2012 09:21:20 GMT

I tried to do it with one field but it did not work out

Re: DYNAMIC COLORS

christian77 — Fri, 27 Jul 2012 10:08:41 GMT

Hi,

Product SubProduct Red Green Blue

A A1 0 0 255

A A2 100 100 255

A A3 200 200 255

In this case, when I see the thing by Product: what color to place? The Red and Green
fields are null(). RGB function interprets that as 0, so the color is 0,0,255, which
is exactly what I wanted.

Also, having the 3 fields null() or empty will result in 0,0,0; that means black.

Set your SubProducts in the same range of colors, like above, and it’ll show the generic one when seeing it by Product.