topic Re: Color change for bar graph in QlikView

Color change for bar graph

Tue, 18 Feb 2014 04:06:15 GMT

Hi All,

I have attached the screen shots because i cannot copy the QVW file.

Dimension : =if(IsNum([Turnaround Time Network Days]), IF([Turnaround Time Network Days]>15, '16 + ', [Turnaround Time Network Days]),'Missing Dates')

Fact : Count([Turnaround Time RAG])

Colors of the bars should be GREEN AMBER and RED based on condition.

Condition : if ([Turnaround Time Network Days])>7, Red()

if ([Turnaround Time Network Days])<=3, Green()

if ([Turnaround Time Network Days])<=7, Amber()

I got the colors but the problem is if [Turnaround Time Network Days]>15 i have grouped into '16+' i want this bar to be in RED(). I am not able to do it. Please help me with this.

Check the screen shots.

Thanks & Regards,

Keerthi

Re: Color change for bar graph

sanketkhunte — Tue, 18 Feb 2014 04:34:45 GMT

Sorry.. I am not getting your exact requirement. Can you put it into other words ?

Thanks
Sanket

Re: Color change for bar graph

Tue, 18 Feb 2014 04:40:17 GMT

I am getting the colors for bar graph. But when the dimension is '16+' the color should be red() but i am not getting.

Please check the screen shot chart, where the color of '16+' dimension is black. I want it to be in red()

Hope this helps in understanding requirement.

Regards,

keerthi

Re: Color change for bar graph

sujeetsingh — Tue, 18 Feb 2014 04:52:39 GMT

plz give a sample

Re: Color change for bar graph

Tue, 18 Feb 2014 05:07:15 GMT

Hi Keerthi,

Try this in condition:

if ([Turnaround Time Network Days])<=3, Green(),

if ([Turnaround Time Network Days])<=7, Amber(), Red()))

Re: Color change for bar graph

Tue, 18 Feb 2014 05:13:01 GMT

there are missing dates as dimension i dont want that to be in red. I am attaching the QVW.

Re: Color change for bar graph

Tue, 18 Feb 2014 05:16:35 GMT

Hi All ,

I have attached thw QVW. Please click on the button to enable the chart.

I want 0 to 3 in green color, 3 to 7 in amber() and 8 to 16+ in red. remaining missing dates in Black.

Thanks & Reagrds,

keerthi

Re: Color change for bar graph

Tue, 18 Feb 2014 05:17:14 GMT

I have attached the sample

Re: Color change for bar graph

sanketkhunte — Tue, 18 Feb 2014 05:29:29 GMT

Keerthi,

I could see below result.. if you require this let me know i will provide you expression

Re: Color change for bar graph

MayilVahanan — Tue, 18 Feb 2014 05:30:12 GMT

Try like this

Expression -> click the '+' sign -> background color

IF([Turnaround Time Network Days] < 3, Green(),

if([Turnaround Time Network Days] < 7, Yellow(), // instead of yellow, use RGB for amber

if([Turnaround Time Network Days] < 16, red(), Black())))

Edit:

Result is like below

Re: Color change for bar graph

Tue, 18 Feb 2014 05:30:49 GMT

Ok then modify the expression as follows:

if ([Turnaround Time Network Days])<=3, Green(),

if ([Turnaround Time Network Days])<=7, Amber(),

if ([Turnaround Time Network Days])>7,Red(),Black())))

Re: Color change for bar graph

Tue, 18 Feb 2014 05:37:00 GMT

I gave the same expression but '16+' is coming in Black

Re: Color change for bar graph

Tue, 18 Feb 2014 05:38:53 GMT

16+ should be in RED.

Re: Color change for bar graph

Tue, 18 Feb 2014 05:39:16 GMT

Please provide me the expression.

Re: Color change for bar graph

Tue, 18 Feb 2014 05:42:17 GMT

I got the issue, it is because '16+' behaves as string while except missing dates all are numeric values. So further little modification required.

if ([Turnaround Time Network Days]<=3, Green(),

if ([Turnaround Time Network Days]<=7, Amber(),

if ([Turnaround Time Network Days]>7 or [Turnaround Time Network Days]='16+',Red(),Black())))

Hope this works.

Re: Color change for bar graph

Tue, 18 Feb 2014 05:46:53 GMT

Still 16+ is coming in black

Re: Color change for bar graph

Tue, 18 Feb 2014 05:50:06 GMT

if (num([Turnaround Time Network Days])<=3, Green(),

if (num([Turnaround Time Network Days])<=7, Amber(),

if (num([Turnaround Time Network Days])>7,Red(),Black())))

Re: Color change for bar graph

MayilVahanan — Tue, 18 Feb 2014 05:55:21 GMT

Create the dimension based on this expression in script and then use that field as dimension in bar chart.

ex:

Load

if(IsNum([Turnaround Time Network Days]), IF([Turnaround Time Network Days]>15, '16 + ', [Turnaround Time Network Days]),'Missing Dates') AS TurnAround,

From tablename;

Then use TurnAround as Dimension.

We can apply color for that dimension.

Re: Color change for bar graph

Tue, 18 Feb 2014 05:57:50 GMT

Sorry again 16+ in Black

Re: Color change for bar graph

sunilkumarqv — Tue, 18 Feb 2014 06:03:29 GMT

Try this

Expression -> click the '+' sign -> background color

IF([Turnaround Time Network Days] < 3, Green(),

if([Turnaround Time Network Days] < 7, Yellow(), // instead of yellow, use RGB for amber

if([Turnaround Time Network Days] ='16+', red())))