Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jchang_snwl
New Contributor II

show % instead of total on bar chart

Hello

I'm look for a solution to display % instead of total value on ca bar chart.

For example,

barshowpercentage.PNG

There are two expressions. Red one shows the total count of defects found, while gray shows the count of not problem found.

If I turn on "Values on Data Points" option, the bar chart shows total of value of red count plus gray count.

How can I make it show the percentage of red out of gray?

Thanks,

Josh

1 Solution

Accepted Solutions
Not applicable

Re: show % instead of total on bar chart

Hi,

You have to create 2 expressions for each category. the category that you want to show %, you need to use Dual function with Num format as %.

It can be shown as % but only when value is plotted inside segment, when value on top, it's still showing as number.

Please see the attached file.

2 Replies
Not applicable

Re: show % instead of total on bar chart

Hi,

You have to create 2 expressions for each category. the category that you want to show %, you need to use Dual function with Num format as %.

It can be shown as % but only when value is plotted inside segment, when value on top, it's still showing as number.

Please see the attached file.

jchang_snwl
New Contributor II

Re: show % instead of total on bar chart

It works great!

Thanks,

Josh

Community Browser