Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
punitpopli
Specialist
Specialist

Pyramid chart in QlikView

Hi All,

We have to develop the chart type as per attached image in QlikView.

Kindly share your thoughts if you have anyone had implemented similar kind of chart in QlikView.

Regards,

Punit

6 Replies
Anonymous
Not applicable

Anonymous
Not applicable

May be mot exactly but workaround I would suggest...

Take a Pyramid Image from google and then use Text box and Line Object Combination to show Data for Pyramids

Not applicable

Hi Punit ,

Refer the below thread .

Creating a Pyramid Chart

HirisH_V7
Master
Master

Hi,

Data:

Data:

LOAD * INLINE [

    Range, M, F

    0-5, 120, 125

    6-10, 110, 120

    11-15, 120, 130

    16-20, 160, 160

    21-25, 150, 180

    26-30, 140, 140

    31-35, 130, 130

    36-40, 120, 120

    41-45, 110, 110

    46-50, 100, 100

    51-55, 100, 90

    56-60, 80, 80

    61-65, 70, 50

    66-70, 60, 60

    71-75, 65, 50

    76-80, 40, 40

    81-85, 30, 40

    86-90, 20, 20

    91-95, 10, 10

    96-100, 5, 5

];

Front End:

  • Create two bar charts,
  1. Dimension:Range and Expression: =sum(M*-1)
  2. Dimension:Range and Expression: =sum(F)
  • Then change style of Chart and axes as of your requirement.

Pyramid Chart.PNG

HTH,

PFA,

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
punitpopli
Specialist
Specialist
Author

Hi balrajahlawat

I have seen the post you have added in above, but they didn't solve the purpose.

May be if you can elaborate more on the workaround will help.

Thanks,

Punit

HirisH_V7
Master
Master

Hi ,

Check this,

Pyramid Chart customising.PNG

Customisation funnel chart,

Hope this helps,

Regards,

Hirish

HirisH
“Aspire to Inspire before we Expire!”