topic Re: Bar Chart with gap and text in QlikView

Bar Chart with gap and text

Tue, 31 Mar 2015 09:08:55 GMT

Hi all,

I have a table like

Type	%	Points
A Batting	95	0.9
A Bowling	86	0.6
B Batting	97	0.7
B Bowling	84	0.5
C Batting	101	1.1
C Bowling	94	0.9

And i want to create a bar chart like this

which should have

1. Space between the various groups A,B and C.

2. Points to indicate on the top of bars and % values in the data points.

Can you please help me with this.

Thanks in advance.

Regards,

Kuldeep

Re: Bar Chart with gap and text

Anonymous — Tue, 31 Mar 2015 09:20:28 GMT

In your load scripts split :

Type Values like A Batting

Into 2 dimensions :

Team Values like A

Play Values like Batting

And have a Bar Chart with 2 Dimensions Grouped.

Re: Bar Chart with gap and text

Anonymous — Tue, 31 Mar 2015 09:24:13 GMT

try to duplicate the expression and untick to show as bar, then only the value should be displayed

Re: Bar Chart with gap and text

MK_QSL — Tue, 31 Mar 2015 09:26:46 GMT

There is no direct way you can show one value inside chart and other value on the top of the bar but we can use tricks and can achieve the same using two different bar chart...

Please check enclosed file..

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 09:39:31 GMT

Hi @kuldeep

i have tried this in my view

just check the attachment

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 09:44:17 GMT

Thanks Bill and Rudolf for your valuable answers

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 09:47:06 GMT

Hey Manish,

Thanks so much. Its very close to what i want.

The only thing is when i try to make the chart from vertical to horizontal orientation, the values moves from the original position.

I wanted to show this with horizontal orientation on style tab.

Regards,

Kuldeep

Re: Bar Chart with gap and text

MK_QSL — Tue, 31 Mar 2015 09:56:07 GMT

Like this?

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 09:58:46 GMT

This is Perfect!

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 10:00:05 GMT

Thank Manish. You are the best!

I can now work my real data to form a chart what i want

Regards,

Kuldeep

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 10:00:41 GMT

And thanks Navven

Re: Bar Chart with gap and text

Tue, 31 Mar 2015 13:17:47 GMT

Hey Manish,

I am doing everything correct. Getting the same results.

Just not getting the numbers of % on the bar.

Don't know where i am going wrong. Could you please help?

Regards,

Kuldeep

Re: Bar Chart with gap and text

MK_QSL — Tue, 31 Mar 2015 13:37:20 GMT

If you check my file... there are two bar charts one on top of other... that's a trick i have used. Try to move the two charts side by side.. .you will realize/understand what i have done...

Let me know if still you are having problem..

Re: Bar Chart with gap and text

Wed, 01 Apr 2015 08:29:42 GMT

Hey Manish,

I tried but still was not able to get the solution.

Considering this data, how to make a similar horizontal bar chart

Team	Type	%	Count
India	Batting	99	-0.9
India	Bowling	95	-0.6
SA	Batting	87	-9.6
SA	Bowling	94	-0.5
AUS	Batting	96	-1.0
AUS	Bowling	93	-0.3
MI	Batting	101	0.2
MI	Bowling	96	-0.1
NZ	Batting	93	-0.9
NZ	Bowling	78	-0.2
RR	Batting	99	-0.5
RR	Bowling	99	0.0
US	Batting	96	-12.6
US	Bowling	95	-1.7

Also i need to put color conditions on the % bar numbers,

If % <95, then green

else if %>95 and %< 100 then amber

and more than 100 then red.

Regards,

Kuldeep

Re: Bar Chart with gap and text

MK_QSL — Wed, 01 Apr 2015 08:41:18 GMT

Check enclosed file..

Re: Bar Chart with gap and text

Wed, 01 Apr 2015 11:46:23 GMT

Finally i got it. This is really awesome and cool trick.

Thanks again