Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display value and percentage in the bar chart

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


12 Replies
laujerry
Creator
Creator

Chart Properties -> Expressions -> Display Options

Check "Values on Data Points"

sadickbasha
Partner
Partner

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
MVP
MVP

May be something like attached sample?

neetu_singh
Partner
Partner

Hi,

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

sample.JPG

mdmukramali
Specialist III
Specialist III

Dear ,

Kindly find the attachment.

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

I hope it will help you,

Thanks,

Mukram.

Not applicable
Author

Brilliant solution 

Not applicable
Author

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

Not applicable
Author

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
Specialist III
Specialist III

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.