Display value and percentage in the bar chart

[#1]

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

[laujerry]

Chart Properties -> Expressions -> Display Options

Check "Values on Data Points"

[sadickbasha]

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

[tresesco]

May be something like attached sample?

[neetu_singh]

Hi,

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

[mdmukramali]

Dear ,

Kindly find the attachment.

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

I hope it will help you,

Thanks,

Mukram.

[#7]

Brilliant solution 

[#8]

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

[#9]

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.

[mdmukramali]

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.