topic Regarding Background Color in Chat dimension and Expression in QlikView

Regarding Background Color in Chat dimension and Expression

qliksus — Fri, 02 Apr 2010 10:39:47 GMT

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.

Regarding Background Color in Chat dimension and Expression

d_pranskus — Fri, 02 Apr 2010 12:51:17 GMT

Hi. Please attach your QVW file. Thanks.

Regarding Background Color in Chat dimension and Expression

Fri, 02 Apr 2010 13:23:34 GMT

Hi,

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

Regarding Background Color in Chat dimension and Expression

qliksus — Sat, 03 Apr 2010 11:05:34 GMT

Hi,

Find the attached file.

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 07:43:55 GMT

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

Regarding Background Color in Chat dimension and Expression

qliksus — Mon, 05 Apr 2010 11:02:13 GMT

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.

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 11:16:13 GMT

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

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 11:30:59 GMT

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

Regarding Background Color in Chat dimension and Expression

qliksus — Mon, 05 Apr 2010 13:12:32 GMT

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??????

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 13:52:43 GMT

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

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 13:54:23 GMT

hi ,

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

Regarding Background Color in Chat dimension and Expression

qliksus — Mon, 05 Apr 2010 14:07:08 GMT

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.

Regarding Background Color in Chat dimension and Expression

qliksus — Mon, 05 Apr 2010 14:12:57 GMT

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.

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 15:03:29 GMT

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

Regarding Background Color in Chat dimension and Expression

Mon, 05 Apr 2010 15:07:42 GMT

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

Regarding Background Color in Chat dimension and Expression

qliksus — Tue, 06 Apr 2010 10:58:26 GMT

Hi,

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