Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

pivot dimension background color


I´m trying to format the color background with this but having trouble

if(Interval = '0-80',rgb(164,216,105))or (Interval = '81-100',rgb(230,224,13)) or (Interval = '101-120',rgb(255,0,0))

please help

1 Solution

Accepted Solutions

Re: pivot dimension background color

Hi,

    Try this.

    if(Interval = '0-80',rgb(164,216,105),

          if(interval = '81-100',rgb(230,224,13),

                    if(Interval = '101-120',rgb(255,0,0)))

Regards,

Kaushik Solanki

2 Replies

Re: pivot dimension background color

Hi,

    Try this.

    if(Interval = '0-80',rgb(164,216,105),

          if(interval = '81-100',rgb(230,224,13),

                    if(Interval = '101-120',rgb(255,0,0)))

Regards,

Kaushik Solanki

Not applicable

Re: pivot dimension background color

Hi Kaushik

works fine - thanx

Community Browser