Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Creating a Pyramid Chart

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

8 Replies
rahulgupta
Contributor III

Re: Creating a Pyramid Chart

Hey hi,

May be this type of chart you are talking about.

Kindly check and revert back.

Regards

Not applicable

Re: Creating a Pyramid Chart

hi rahul,

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

9.jpeg

Not applicable

Creating a Pyramid Chart

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

Not applicable

Re: Creating a Pyramid Chart

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

MVP
MVP

Re: Creating a Pyramid Chart

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

Not applicable

Re: Creating a Pyramid Chart

khadeer_sparks
Valued Contributor

Re: Creating a Pyramid Chart

See the qvw file

Regards,

Khadeer

Not applicable

Re: Creating a Pyramid Chart

thank you so much for your resp9onses

Community Browser