Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pranaview
Creator III
Creator III

How to show both number and percentage value on a Pie chart in QlikView

Hi Guys,

I'm trying to display values on data points on a pie chart in both number and relative percentage but i'm only able to achieve one of them. So, either i'm able to show the values in number or in percentage but my task is show it in both simultaneously, I thought of using text object with the expression in it but that won't work as the placement of the object will be static and when data changes or if user do some selections then it won't make any sense.

Is there anyway to achieve this in QlikView?

Any help or suggestions will be hugely appreciated.Sample chart attached below

PieChart.PNG

8 Replies
vijetas42
Specialist
Specialist

You can add one more expression in pie chart and make it text as pop up and show that expression as relative.

tresesco
MVP
MVP

You can use two expressions one for % and another for absolute value.

Capture.JPG

jensmunnichs
Creator III
Creator III

Hey,

Still fairly new to Qlikview myself, but I think this is what you're looking for:

1. Create another expression with the same definition as the one you used to calculate your values

2. Check 'Relative' for the second expression, under the 'comment' input field

3. Check 'Values on data points' for both expressions

4. Adjust presentation/number format as you wish (I think default for relative expressions is percentage fixed to 2 decimals)

Hope this helps, and again I'm fairly new to Qlikview so there might be a better solution.

pranaview
Creator III
Creator III
Author

Thanks Vijeta, it worked nicely. Just one more thing that I wanted to discuss is, can we make the size of Pie/Donut chart static. Currently it keeps on changing depending on the user selection.

pranaview
Creator III
Creator III
Author

Thanks for the solution Jens. Even I'm very new this tool.I have done exactly what you have mentioned and it works nicely. Just facing another problem though. Size of the Donut just keeps on changing based on the user selection.

Again thanks for your answer.

pranaview
Creator III
Creator III
Author

Thanks Tresesco, this works.

jensmunnichs
Creator III
Creator III

I had a look around but I couldn't really find a solution as simple as checking a 'static size' box or anything unfortunately...

Since the chart seems to get smaller to make space for the labels, one option would be to simply make the chart big or small enough to fit all the labels regardless of selection (So either big enough to the point where the largest labels don't reduce the size of the chart or big enough so any label reduces the size of the chart and it's permanently small).

Keep in mind that you might be able to reduce the size of your labels by limiting decimals or (if your values are very large) by showing your values x1000 or something like that, or by changing the font size.

Another solution would be to move your legend around by clicking on the chart and holding ctrl+shift. Some red lines will show that allow you to resize the individual parts of your chart. You could also limit the length of your legend in Chart properties > Presentation tab > Limit legend (characters).

Hope this helps you. Remember to mark a comment as the correct answer if your question was answered

pranaview
Creator III
Creator III
Author

I'm only getting an option to "Mark as Helpful" for some reason which I already did. Thanks a lot for your help.