Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

How to create a Square Pie Chart

cancel
Showing results for 
Search instead for 
Did you mean: 
Alexander_Thor
Employee
Employee

How to create a Square Pie Chart

Attachments

This technical brief walks you through the process of creating a Square Pie Chart in QlikView.

It makes use of the following techniques:

  • Pivot Tables
  • ValueLoop() as a Calculated Dimension
  • Advanced Chart Formatting

Please note that Square Pie, and normal round ones, are not always the best way to visually represent part-to-whole data.

Labels (1)
Comments
Not applicable

Interesting, Thanks Alexander.

0 Likes
Christian_Lauritzen
Partner - Creator II
Partner - Creator II

Very creative! Thanks

0 Likes
Christian_Lauritzen
Partner - Creator II
Partner - Creator II

A much less sophisticated variant is to use boxes on the top layer to create the following illusion;

Square Pie Chart.png

julian_rodriguez
Partner - Specialist
Partner - Specialist

Wow it's great!!... thanks for sharing!

Christian_Lauritzen
Partner - Creator II
Partner - Creator II

Thanks Julian!

0 Likes
Christian_Lauritzen
Partner - Creator II
Partner - Creator II

I would not recommend using this chart (not Alexander's great example, but my graphic above) as it can be very misleading, even if it has a nice look to it.

0 Likes
ThornOfCrowns
Specialist II
Specialist II

Nice implementation. I like the "square pie" better than the traditional as the data is much more readable at a glance.

0 Likes
Not applicable

Could you please explain me how to create a 'Square pie chart' which is shown above as screenshot?

0 Likes
ThornOfCrowns
Specialist II
Specialist II

It's a normal Pie Chart with some white text boxes overlaid in the Top Layer to 'square the circle'.

0 Likes
Not applicable

Thanks for your response.. but i still cannot create it. could you please tell me the procedure to create?

0 Likes
Version history
Last update:
‎2013-07-01 10:43 AM
Updated by: