Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

groveliam
Contributor

Expand Pivot Tables upwards

Hey Everyone,

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

dimensions.PNGand 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.

6 Replies
vamsee
Valued Contributor

Re: Expand Pivot Tables upwards

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

Khan_Mohammed
Honored Contributor II

Re: Expand Pivot Tables upwards

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
Contributor

Re: Expand Pivot Tables upwards

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

groveliam
Contributor

Re: Expand Pivot Tables upwards

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

Re: Expand Pivot Tables upwards

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
Valued Contributor II

Re: Expand Pivot Tables upwards

Hi Liam,

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

G.

Community Browser