topic Re: Help me in writing dimension? in QlikView

Help me in writing dimension?

durgabhavani — Fri, 24 Apr 2015 07:59:52 GMT

Hi All,

I have one dimension as below:

Duedays

< 10 days

= 10 days

< 10 days

Now i want to write caliculated dimension for barchart

if Duedays < 10 days then bar should be green

if Duedays = 10 days then bar should be orange

if Duedays < 10 days then bar should be red

Please advice.

Thanks,

durga

Re: Help me in writing dimension?

durgabhavani — Fri, 24 Apr 2015 08:03:27 GMT

last value is > 10 days I wrote < 10 days value two times.

Please consider and advice.

Re: Help me in writing dimension?

ankitaag — Fri, 24 Apr 2015 08:06:42 GMT

Hi,

Click the + option of the Duedays dimension.. Double click the background color.. Write the expression as

=if(Duedays < 10 days,RGB(0,255,0),if(Duedays=10 days,RGB(255,128,0),rgb(255,0,0)))

Re: Help me in writing dimension?

PrashantSangle — Fri, 24 Apr 2015 08:07:15 GMT

Hi,

USe DueDays as your dimension

the cilck on + symbol

BackgroundColour

write condition

if(Duedays < 10,green(),if(Duedays >10,Red(),RGB(of ORANGE)))

Regards

Re: Help me in writing dimension?

durgabhavani — Fri, 24 Apr 2015 08:30:50 GMT

Hi Ankitha/Max

I am unable to find the changes in my barchart. What might be the problem?

Thanks,

Durga

Re: Help me in writing dimension?

awhitfield — Fri, 24 Apr 2015 08:40:56 GMT

Hi Durga,

simple example attached

Regards

Andy

Re: Help me in writing dimension?

durgabhavani — Fri, 24 Apr 2015 08:46:34 GMT

andrew,

Please share screenshot, i am unable to open qvw in office due to security reasons.

I wrote the above conditions in my barchart backgroud color expression but color is not changing for bars.

waiting for reply.

Thanks,

Durga

Re: Help me in writing dimension?

ankitaag — Fri, 24 Apr 2015 09:00:02 GMT

Hey,

Write the background color expression in expression value.

see the attached inliune

Re: Help me in writing dimension?

awhitfield — Fri, 24 Apr 2015 09:03:46 GMT

Ok,

chart has DueDays as dimension and Count(DueDays) as the expression, the background colour is set against the expression with the following :

if(DueDays < 10,green(), if(DueDays =10,RGB(225,128,0) ,Red()))

The data loaded was:

DueDate:
Load * Inline
[
DueDays
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
];

And the chart looks like this:

Regards

Andy

Re: Help me in writing dimension?

durgabhavani — Fri, 24 Apr 2015 09:10:13 GMT

Thanks anikta and andrew, it is working.

I am writing this condition for dimension. it is not working for dimension. but working for expression.

Once again thanks.

Please see my another question in recent thread.

Help me in writing expression to indicate bulb and advice.

Durga.