topic Re: Pyramidal Graph in QlikView

Pyramidal Graph

Wed, 25 Nov 2020 16:16:04 GMT

We use a 'partnership pyramid' to show our relationship status with suppliers. Where they are on the pyramid is determined by their audit scores - I want to be able to pull these scores from an excel log, but have them displayed in the same format as the pyramid, 'filling up' the green as we improve on our trading relationship. I've attached a sample of the pyramid - I want each segment to turn green as a supplier achieves each status, if that makes sense. Is this possible? If so, may I ask how?

Re: Pyramidal Graph

Gysbert_Wassenaar — Thu, 10 Mar 2016 12:46:52 GMT

There's no pyramid chart available. Maybe you can abuse the funnel chart or one of the gauge chart styles. Or simply use text boxes with images for each segment in each color, so 10 text boxes with images. Then show/hide the text boxes as needed based on the scores.

Re: Pyramidal Graph

santiago_respane — Thu, 10 Mar 2016 13:19:45 GMT

Hi Hannah,

when it comes to charts that Qlikview doesn't offer i go with Google Charts, you can add them as expression in table charts, as images in text objects and the work pretty good.

Some options for you to review:

https://community.qlik.com/thread/32554

https://community.qlik.com/docs/DOC-13122

Let me know if this helps.

Kind regards,