topic Creating a Pyramid Chart in QlikView

Creating a Pyramid Chart

Thu, 28 Jul 2011 07:23:56 GMT

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

Re: Creating a Pyramid Chart

rahulgupta — Tue, 02 Aug 2011 06:22:58 GMT

Hey hi,

May be this type of chart you are talking about.

Kindly check and revert back.

Regards

Re: Creating a Pyramid Chart

Tue, 02 Aug 2011 08:15:17 GMT

hi rahul,

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

Creating a Pyramid Chart

Thu, 29 Sep 2011 12:07:33 GMT

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

If you

sort by y value - decending
have the same colour for both the positive and negative mirror
high the x axis
only show values on data points for the positive element
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

Re: Creating a Pyramid Chart

Fri, 20 Jul 2012 10:47:55 GMT

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

Re: Creating a Pyramid Chart

swuehl — Fri, 20 Jul 2012 11:07:21 GMT

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

Re: Creating a Pyramid Chart

Fri, 20 Jul 2012 12:08:29 GMT

thank you swuehl, this worked like a treat.

many thanks

Re: Creating a Pyramid Chart

khadeer — Fri, 20 Jul 2012 12:26:39 GMT

See the qvw file

Regards,

Khadeer

Re: Creating a Pyramid Chart

Fri, 20 Jul 2012 12:38:38 GMT

thank you so much for your resp9onses