topic Re: Pick function for a background color doesn't work in QlikView

Pick function for a background color doesn't work

Dafna2020 — Sat, 16 Nov 2024 01:30:33 GMT

Hi,

I defined colors for a conditional background:

KPIsColors:
//1=Red,2=light red,3=yellow,4=light green,5=green
LOAD *,Dual(_PickColorExp,_PickColorCodeNum) as PickColorRGB INLINE [
_PickColorCodeNum , _PickColorExp
1 , 'RGB(234,102,83)'
2 , 'RGB(245,183,175)'
3, 'RGB(230,219,91)'
4, 'RGB(172,209,24)'
5, 'RGB(111,149,21)'
];

Each condition compares a metric to 5 limits:

=Pick(num(PickColorRGB),
     ($(eYoYGrowth%_PrevYear) <=vRed%)*-1,
     ($(eYoYGrowth%_PrevYear) <=vLightRed%)*-2,
     ($(eYoYGrowth%_PrevYear) <=vYellow%)*-3,
     ($(eYoYGrowth%_PrevYear) <=vLightGreen%)*-4,
     ($(eYoYGrowth%_PrevYear)>vLightGreen%)*-5)

But the Pick function does not work as expected..

There is no background color..

Any Idea why?

Thanks!

Re: Pick function for a background color doesn't work

Arthur_Fong — Wed, 15 Jan 2020 08:55:16 GMT

Try:

=Pick(match(_PickColorCodeNum,1,2,3,4,5)
     ($(eYoYGrowth%_PrevYear) <=vRed%)*-1,
     ($(eYoYGrowth%_PrevYear) <=vLightRed%)*-2,
     ($(eYoYGrowth%_PrevYear) <=vYellow%)*-3,
     ($(eYoYGrowth%_PrevYear) <=vLightGreen%)*-4,
     ($(eYoYGrowth%_PrevYear)>vLightGreen%)*-5)

Re: Pick function for a background color doesn't work

Dafna2020 — Wed, 15 Jan 2020 09:07:12 GMT

Hi,

Thank you...

Tried.. but it doesn't work..

Re: Pick function for a background color doesn't work

Arthur_Fong — Wed, 15 Jan 2020 09:10:32 GMT

You have a sample app?

Re: Pick function for a background color doesn't work

Dafna2020 — Wed, 15 Jan 2020 09:32:40 GMT

No...

Re: Pick function for a background color doesn't work

Kushal_Chawda — Wed, 15 Jan 2020 09:42:04 GMT

I think this is not the correct way to map the colors. You need to check first expression condition and then define the color there. May be you can try something like below

Pick(match(-1,
     ($(eYoYGrowth%_PrevYear) <=vRed%),
     ($(eYoYGrowth%_PrevYear) <=vLightRed%),
     ($(eYoYGrowth%_PrevYear) <=vYellow%),
     ($(eYoYGrowth%_PrevYear) <=vLightGreen%),
     ($(eYoYGrowth%_PrevYear)>vLightGreen%)),

RGB(234,102,83),
RGB(245,183,175),
RGB(230,219,91),
RGB(172,209,24),
RGB(111,149,21))

Re: Pick function for a background color doesn't work

Dafna2020 — Wed, 15 Jan 2020 12:30:52 GMT

It works!

I used variables for the colors...:

Pick(match(-1,
$(eYoYGrowth%_PrevYear) <=vRed%,
$(eYoYGrowth%_PrevYear) <=vLightRed%,
$(eYoYGrowth%_PrevYear) <=vYellow%,
$(eYoYGrowth%_PrevYear) <=vLightGreen%,
$(eYoYGrowth%_PrevYear)>vLightGreen%),
$(vRGBRed),$(vRGBLightRed),$(vRGBYellow),$(vRGBLightGreen),$(vRGBGreen))

Thanks!