topic Re: COLOURS WITH CONDITIONS in QlikView

COLOURS WITH CONDITIONS

Wed, 20 Aug 2014 08:18:49 GMT

good morning, My name's Genny and I work in VR46 the Valentino Rossi's company, I have a problem with the colors on Qlik view and I would like to know if and how I could solve it.

When assigning the background color to a dimension, I use the following routine

=IF ([name dimension]=1,GREEN())

This routine is perfect if I filter the dimension with value = 1 but it is not working without filter. without the filter, the color (green) doesn't appear.

Can I ALWAYS have a colored dimension (i.e. Green) (even if I haven't filter) ?

thanks!!!!!

Re: COLOURS WITH CONDITIONS

tresB — Wed, 20 Aug 2014 08:22:11 GMT

It should work fine without condition as well. Could you share a sample that shows the issue?

Re: COLOURS WITH CONDITIONS

Wed, 20 Aug 2014 08:25:56 GMT

Hi Genni,

It should without if condition as well.

Try

= RGB(0,255,0)

Thanks!

Re: COLOURS WITH CONDITIONS

jagan — Wed, 20 Aug 2014 08:38:01 GMT

Hi,

Do you have that dimension declared in Dimension tab? If not try using

=IF (Max([name dimension])=1,GREEN())

If not working attach sample file.

Regards,

Jagan.

Re: COLOURS WITH CONDITIONS

maleksafa — Wed, 20 Aug 2014 08:43:05 GMT

you can simply put in the background color only the expression =Green() or use RGB() colors, without any if conditions.

Re: COLOURS WITH CONDITIONS

Wed, 20 Aug 2014 08:59:15 GMT

I tried ... nothing to do

as soon as I can, I send an example thanks

Re: COLOURS WITH CONDITIONS

fred_s — Wed, 20 Aug 2014 09:34:45 GMT

Hi,

You could try to add an else, like

=IF ([name dimension]=1,GREEN(),RED())

See attchment

Fred

Re: COLOURS WITH CONDITIONS

Wed, 20 Aug 2014 11:43:11 GMT

perfect !!!! With the "else" is ok!!!!!

THANKS!!!!

However, for multiple conditions which is the syntax in qlik?

If I have many "IF conditions" (and then many colours)?

Re: COLOURS WITH CONDITIONS

fred_s — Wed, 20 Aug 2014 11:46:26 GMT

Hi Genni,

You can use nested IF:

=IF ([name dimension]=1,GREEN(),

IF([name dimension]=2,YELLOW(),

RED()

)