Expand Pivot Tables upwards

[groveliam]

Hey Everyone,

Is there a way to expand pivot tables upwards, meaning show the sub dimensions above the parent dimensions? Currently I have:

and I am wondering if it is possible to have it display like:

     +Business

     +Government Account

     +Personal

-Central

     +Personal

-Other

     +Business

     +Government Account

     +Personal

-South

Thank you for any help! I will also attach sample data.

[vamsee]

Hello Liam,

Hope this would help you.

Hierarchy in QlikView

Hierarchy function easy and Efficient with example---

Especially please look at the awesome white paper by HIC.

Hierarchies

Thanks

Vamsee

[MK9885]

Why not swap the dimension?

You Sub Node will be on top and node after expansion?

To create a Hierarchy you'd need NodeID and ParentID

[groveliam]

Nah I need the business, government, and personal to still open from the regions. I just want them to expand upwards.

[groveliam]

Hey stalwar1‌‌ do you have any ideas? Sorry to @ you, just know you're the man with answers.

[sunny_talwar]

I might have been able to help if this was QlikView, but I don't think I know a way to do this in Qlik Sense... may be look for an extension or create one

[undergrinder]

Hi Liam,

I think it is not possible. It is against Sense's sense

G.