topic Re: Change Background Color of a bar chart based on some field in QlikView

Change Background Color of a bar chart based on some field

udaya_kumar — Mon, 14 Jan 2013 09:59:22 GMT

Hi,

I have an Inline field created in edit script by name consider Fruit.

It has values like All, Apple, Banana, Orange, Mango, Pineapple.

I have a database field by name FRUIT.

These two Fruit and FRUIT are linked in the script like

All,Apple

All,Banana

All,Orange

All,Mango

All,Pineapple

Apple,Apple

Banana,Banana

Orange,Orange

Mango,Mango

Pineapple,Pineapple

I am using Fruit field in my Listbox as filter and FRUIT as a dimension in the Bar Chart.

I have applied the background color for FRUIT in the expression in the Chart, background color.

It is working fine. but when we select any value from listbox like "Apple",

then only Apple is shown in red color in the chart and other values are shown in the basic blue color.

But it should show the color defined in the expressions even if user selects any value from Listbox.

How we can achieve this?

Re: Change Background Color of a bar chart based on some field

neha_shirsath — Mon, 14 Jan 2013 10:08:35 GMT

Hi Uday,

Can you attach some data file? So that it will be more clear to understand.

Re: Change Background Color of a bar chart based on some field

sujeetsingh — Mon, 14 Jan 2013 10:11:04 GMT

ye ??

Re: Change Background Color of a bar chart based on some field

nirav_bhimani — Mon, 14 Jan 2013 10:15:24 GMT

HI,

Try this,

If ( WildMatch (Fruit , 'Apple'), RGB(0, 255, 0), RGB(192, 192, 192,) )

Or else try same condition in nested If

Regards,

Nirav Bhimani

Re: Change Background Color of a bar chart based on some field

Anonymous — Mon, 14 Jan 2013 10:20:17 GMT

This post may offer a solution, by adding the RGB code into the data model, and assosicating to the required dimensions: http://community.qlik.com/message/291658#291658

Jonathan

Re: Change Background Color of a bar chart based on some field

udaya_kumar — Mon, 14 Jan 2013 11:54:40 GMT

Hi all,

Thanks for the reply,

I tried with the help of my colleague.

We tried like the below code,

If(RowNo()=1, RGB(114,103,241),

If(RowNo()=2, RGB(243,70,1),

If(RowNo()=3, RGB(1,228,120),

If(RowNo()=4, RGB(2,208,206),

If(RowNo()=5, RGB(2,0,205),

If(RowNo()=6, RGB(253,153,203)

))))))

It worked for me