Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

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

I have the following Barchart

Numbers.JPG

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

Percentage.JPG

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

Thanks

Tags (2)
1 Solution

Accepted Solutions
perumal_41
Valued Contributor II

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

Hi.

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

12 Replies
Not applicable

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

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

Not applicable

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

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?NumbersPercentage.jpg

Not applicable

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

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

Regards,

Kiran

Not applicable

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

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.

overlap.png

Not applicable

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

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.

Not applicable

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

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

perumal_41
Valued Contributor II

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

Hi

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

Regards,

Perumal

Not applicable

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

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

perumal_41
Valued Contributor II

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

Hi.

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