topic Color using GetCurrentField() in QlikView

Color using GetCurrentField()

Anonymous — Thu, 26 Dec 2013 16:05:55 GMT

Hi,

I have a RGB set for one dimension, but I'm working on a Pie Chart with two dimensions. Now, If I set the expression color based on the RGB(R, G, B) when I drill-down in the group all the colors are gone (it looks black). How can I have the RGB for the first dimension and like random colors for the second one (can be the original ones).

I tried this expression:

If(GetCurrentField([Actividad-Oportunidad]) = 'Oportunidad', RGB(R, G, B), RGB(R * rand(), G * rand(), B * rand()))

But I didn't like the result.

Thanks in advance, kindest regards.

Re: Color using GetCurrentField()

Nicole-Smith — Thu, 26 Dec 2013 16:12:53 GMT

What about this instead:

If(GetCurrentField([Actividad-Oportunidad]) = 'Oportunidad', RGB(R, G, B), RGB(255 * rand(), 255 * rand(), 255 * rand()))

Re: Color using GetCurrentField()

Anonymous — Thu, 26 Dec 2013 16:27:48 GMT

Thanks!!! that worked better!