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.

[#2]

hi ,

here i have also attached a screenshot of my script which i have used

[qliksus]

Hi,

Thanks for reply. Please find attached DATA.xls and do the needful. Hope i will get my output very soon.

Waiting for your reply.

[qliksus]

Hi,

As per instruction given by you i have written in script as set nulldisplay='-'. But the output came same. Nothing changed. Please find the attached DATA.qvw file also. Waitinf for your reply.

[#5 · Accepted solution]

hi qliksus,

sorry for the delay but i didn't notice that you were importing data from an excel file.

nulldisplay only works when you are importing data from odbc

so, what you should do now is go to chart properties presentation tab and uncheck suppress zerovalues there.

now it should work fine

thanks

[#6]

hi qliksus,

sorry for the delay but i didn't notice that you were importing data from an excel file.

nulldisplay only works when you are importing data from odbc

so, what you should do now is go to chart properties presentation tab and uncheck suppress zerovalues there.

now it should work fine

thanks

[qliksus]

Hi,

Thanks for reply. I think now my application will work fine.