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?
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.
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.
