topic Re: Display value and percentage in the bar chart in QlikView

Display value and percentage in the bar chart

Thu, 07 Nov 2013 03:53:33 GMT

hi,

As per the requirement, I have to display the value and the percentage in the single bar in the bar chart.

Let me know, Is there any option to implement this requirement.

Thanks in advance,

Smitha

Re: Display value and percentage in the bar chart

laujerry — Thu, 07 Nov 2013 04:06:54 GMT

Chart Properties -> Expressions -> Display Options

Check "Values on Data Points"

Re: Display value and percentage in the bar chart

sadickbasha — Thu, 07 Nov 2013 04:09:08 GMT

Hi Smitha,

Pls refer attached a sample application, you have to include the same expression twice in the bar chart then when you click the 2nd expression there will be 'Group' button below the expressions. using that you can group the expressions

for the 2nd expression check the 'Relative' check box and the number format should be Percentage.

hope this meets your requirement

Re: Display value and percentage in the bar chart

tresB — Thu, 07 Nov 2013 04:17:19 GMT

May be something like attached sample?

Re: Display value and percentage in the bar chart

neetu_singh — Thu, 07 Nov 2013 07:58:28 GMT

Hi,

May be your requirement is like this: plz find attached qvw.

Re: Display value and percentage in the bar chart

mdmukramali — Thu, 07 Nov 2013 09:28:05 GMT

Dear ,

Kindly find the attachment.

In the sample file i used Dual function to achieve it.

I hope it will help you,

Thanks,

Mukram.

Re: Display value and percentage in the bar chart

Thu, 07 Nov 2013 10:08:46 GMT

Brilliant solution

Re: Re: Display value and percentage in the bar chart

Fri, 08 Nov 2013 04:17:52 GMT

Hi Mukhram,

Thanks for the solution, I was looking for the same solution.

Is there any other alternative to implement the same requirement other than dual function.

I want to use this in the set expression.

Please find the .qvw

Re: Display value and percentage in the bar chart

Fri, 08 Nov 2013 05:34:54 GMT

Hi Mukaram,

Thanks for the post.

I'm using Qlikview personal edition. I can't open the qvw file.

Can u please post the dual function.

Thanks in Advance.

Pavan Kumar.

Re: Display value and percentage in the bar chart

mdmukramali — Fri, 08 Nov 2013 10:54:09 GMT

Dear Pavan,

=dual( Sum([Test Score]) & ' (' & num((Sum([Test Score]))/(Sum(Total [Test Score])),'##.0%') & ')',

Sum([Test Score]) +(sum([Test Score]))/(Sum(Total [Test Score]))/100 )

Thanks,

Mukram.

Re: Display value and percentage in the bar chart

Fri, 20 Dec 2013 11:53:08 GMT

Hi Mukram Ali,

I have a small issue,

If I have 1 dimension, 4 expressions (using stacked bar chart).

Please tell me how to do ?

Regards,

Pavan.

Re: Display value and percentage in the bar chart

Anonymous — Thu, 22 Jan 2015 07:23:57 GMT

I have the similar query like Pavan.. that is i have 1 dimension and 2 expressions. I have implemented the way Sadick has said, but the procedure is working for the last expression alone and the first one shows nothing on the bar as data points.

Please help me. Thanks in advance..

Best

Suchitra

Re: Display value and percentage in the bar chart

Wed, 01 Jun 2016 07:04:55 GMT

Thanks !!
Explanation helped