topic Re: Re: Conditional color in QlikView

Conditional color

Mon, 08 Dec 2014 13:31:10 GMT

Hi everyone,

I have a text box with a background color. I would like this background color to change according to the selection : if there is at least one selection in the document vs no selection. How can I do that ?

I have found in the color parameter of the text box that I can add a "calculated" color. I guess I can do something like "if (condition, RGB (x,y,z) , RGB (x,y,z))

But I don't know which function I can use for the condition...

Thank you for your help !

Re: Conditional color

mato32188 — Mon, 08 Dec 2014 13:34:04 GMT

Hi Laura,

if (GetCurrentSelection() > 0, ...)

Martin

Re: Conditional color

its_anandrjs — Mon, 08 Dec 2014 13:37:42 GMT

Hi,

Write the expression in the Color Area

=if (GetSelectedCount(FieldName), RGB(251,241,10) , RGB (154,123,254))

Chart Properties >> Color >> BAse color Calculated >> =if (GetSelectedCount(FieldName), RGB(251,241,10) , RGB (154,123,254))

Regards

Anand

Re: Conditional color

Mon, 08 Dec 2014 13:43:32 GMT

Thank you Anan.

What if I don't want to specify a field name ? I just want my color to change if there is one selection in the document (no matter on which field) ?

Re: Conditional color

its_anandrjs — Mon, 08 Dec 2014 13:57:01 GMT

Hi,

Then you can put the Or condition

=if (GetSelectedCount(Field1) > 0 or GetSelectedCount(Field2) > 0 , RGB(251,241,10) ,Green())

Regards

Anand

Re: Re: Conditional color

mato32188 — Mon, 08 Dec 2014 13:59:50 GMT

if( GetCurrentSelections()>0, RGB(), RGB())

Re: Conditional color

simenkg — Mon, 08 Dec 2014 14:00:02 GMT

you can try:

=if(sum(Aggr(sum(GetSelectedCount($Field)),$Field))>0, RGB(251,241,10) ,Green())

Re: Conditional color

its_anandrjs — Mon, 08 Dec 2014 14:05:02 GMT

Hi Laura.

Here a solution for you in the text object write expression

Chart Properties >> Color >> Base color Calculated >>

=if(Count( Getcurrentselections ( ) ) > 0, QlikTechBlue() , QlikTechGray())

This works for all fields when ever any selection in the list box

Regards

Anand

Re: Conditional color

Mon, 08 Dec 2014 14:12:41 GMT

The 's' was missing in your first message, that's why it didn't work.

Thank you Martin

Re: Conditional color

mato32188 — Mon, 08 Dec 2014 16:03:21 GMT

Sorry for that