Regarding Background Color in Chat dimension and Expression

[qliksus]

Hi,

I am trying to set the background color for expression in a pivot chart, but clor coding changes partially. i:e Means wherevere there is a value in experssion color changes but for no value (Blank value in Expression) color doesn't change. I am attached my DATA.qvw file, in that file only one chart is there. For the chart i have set the color coding for the Dimension - Interval like 0-90(Green),91-150(Yellow) and 151-180(Red).

Now take the case for 0-90, For 1st brand there is no value that's why Green color is not coming wherever for Brand-2 Green color is coming. samething also in 151-180. But i want for 0-90 Green color should come for all value in 0-90. Please give me a solution to do . waiting for reply.

[d_pranskus]

Hi. Please attach your QVW file. Thanks.

[#3]

Hi,

What about setting your default color to green in your chart. This way, all entries with no values would be green as desired.

[qliksus]

Hi,

Find the attached file.

[#5]

hi qliksus,

you can write

set nulldisplay=' - ' in your script

and then set the background colour according to intervals in your chart.

it should work fine now.

thanks

[qliksus]

Hi Tauqueer,

Cay you tell me how to give the condition in Chart? Because the intervals 0-90,151-180 etc are my dinension valuesn . Using pivot chart properties i just changed the format. How to set coloe coding expression in a single expression in a pivot chart?????

Waiting for reply.

[#7]

hi qliksus,

the condition which you have used in your chart for displaying different colours for different intervals works fine

u only need to include

set nulldisplay=' - ' in your script

thanks

[#8]

hi qliksus,

u can use

=if(value>=0 and valuel<=90',LightGreen(),if(value>=91 and value<=150,Yellow(),if(value>=151 and value<=180,RGB(243,113,168),if(value>180,RGB(255,81,81)))))

as an expression in your chart where your field value will contain any arbitrary values now.

thanks

[qliksus]

Hi,

Thanks for reply. But i have also written samething but nothing happens. Onething i want to tell you that 0-90 is the range of days (Defined in a dimension field, Just go through the QVW file) as compared between two date field days. Can you do same thing in the DATA.qvw file and send me back?????

Waiting for your reply??????

[#10]

hi ,

i don't have your excel data file so i cannot reload your application.pls send me that.

i m sending u a screen shot of one of my application and it is working fine for me