Creating a Pyramid Chart

[#1]

how to use pyramid chart in qlikview and to change values dynamically if iam having listbox of 10 years

[rahulgupta]

Hey hi,

May be this type of chart you are talking about.

Kindly check and revert back.

Regards

[#3]

hi rahul,

             i got that pyramid chart by using two expression and i selected properties->style->stacked...........

[#4]

Taking viduthalai's version a little further, it is possible to show a style of pyramid.

If you

1.      sort by y value - decending
2.      have the same colour for both the positive and negative mirror
3.      high the x axis
4. only show values on data points for the positive element
5. Disable popup lables (presentation tab)

You should end up with what you're looking for. Of course there are a few downsides to this approach.

• if you export the data you will see both positive and negative values
• fast changing to a pivot will also show both expresions.

Regards,

Pete

[#5]

Hi fellow qlikers and viewers

I am trying to create a pyramid chart and just wondered if anyone had figured out how to remove the '-' aspect of the data point when "Values on Data Points" is enabled?

Thanks in adnvance

[swuehl]

If you want to remove the negative sign of the value on data points, you can use a number format code for the expression, where the neagtive part equals the positive part, for an integer it might look like

#,##0;#,##0

(set this format in number tab)

To change also the appearance of the axis labels, I think I needed to set a static step in axes tab.

Hope this helps,

Stefan

[#7]

thank you swuehl, this worked like a treat.

many thanks

[khadeer]

See the qvw file

Regards,

Khadeer

[#9]

thank you so much for your resp9onses