topic How do I show % in Barchart? - Updated.. in QlikView

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 02:02:05 GMT

I have the following Barchart

If I create a separate chart for % it will be look like below

I want to combine this two (show numbers and % with in bar chat) into one chart. How do I do it?

Thanks

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 02:50:49 GMT

Having both expression in one chart (with toggle if needed) is one way to show both. If you want one bar with both values since one bar can have only one value one expression is to be made transparent. Like a combo chart with expression one as bar, expression two as line with value on data points, two scales and making 2nd expression color transparent.

Kiran Rokkam

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 03:14:41 GMT

Hi Kiran,

Thanks for the reply. At present I have a expression for individual bars. Also the upper limit is 355 for Y axis and if we add additional bar with % may not work.

Basically I want the chart look like below. How do I?

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 03:23:39 GMT

Write a % expression as line chart, enable value on data points and expression color transparent.

Regards,

Kiran

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 03:50:00 GMT

Kiran

Color Transparent: Where I should set? I tried clicking the Properties->Color-> then moving transparency slider from 0% to 100%. It is not helping.

ALso the values are overlapped. see below chart.

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 03:58:20 GMT

I thought your bars represent one expression. Since each bar itself is an expressions my earlier suggession wont work . The option I see now is using text in chart. If I find another way I shall post.

Kiran.

How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 04:03:57 GMT

I noticed there is a function called DUAL. Do you know whether I can use this in Barchart? How do I?

How do I show % in Barchart? - Updated..

perumal_41 — Thu, 24 Nov 2011 06:05:36 GMT

can u Upload ur file .so that i can try to work and find a solutions for ur query?

Regards,

Perumal

Re: How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 09:27:29 GMT

Hi Perumal

Thanks for the help. Here is the file

Perumal A wrote:
Hi
can u Upload ur file .so that i can try to work and find a solutions for ur query?
Regards,
Perumal

Re: How do I show % in Barchart? - Updated..

perumal_41 — Thu, 24 Nov 2011 11:08:30 GMT

Hi.

I attached one file .please check it is correct or not .

Re: How do I show % in Barchart? - Updated..

Thu, 24 Nov 2011 13:42:01 GMT

Hi,

I don't know if this could resolve your issue but i tried to replicate something similar. As you see the difference is multicolor option because this option is disabled in this graph.

I hope that helps you.

Regards

Xerx

Re: How do I show % in Barchart? - Updated..

Anonymous — Thu, 24 Nov 2011 14:33:15 GMT

Hi,

Maybe this is a solution?

//Peter

Re: How do I show % in Barchart? - Updated..

Wed, 30 Nov 2011 14:01:43 GMT

Hi Everyone

Thanks a lot for all your help.

Perumal,

Thanks for your help. Initially I was struggling as all the Text are placed in one side I was not sure how to align and move. Finally One of my friends told me press shift and Control together then move. It worked.. Appreciate your help.

Peter,

Nice thought. Different way to show the information. Thanks

Xerx, I am using Personal edition now. Qlik view reports error it says I have used all the maximum number of recoveries allowed. So I am unable to see.

Good to see a strong community which help each other. Keep it up guys..