Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Please visit COVID-19 group to keep up the discussion. GO TO GROUP
Highlighted
New Contributor II

Multi-level pivot

Hello all. I am new to Qlik Sense and I need to create what has turned out to be a somewhat complicated table. I need to break down numbers of systems with different versions of software by region, then by business group, as shown in example. Can someone help me? 

clipboard_image_1.png

1 Solution

Accepted Solutions
Highlighted
Contributor

Re: Multi-level pivot

Can you show in qlik how the pivot is looking like ?  

Did you also check the options in the presentation option - indented rows ?

View solution in original post

4 Replies
Highlighted
Contributor

Re: Multi-level pivot

Hi ! 

 

A simple pivot table isnt working ?  are these feilds in your data model ?

 

Cheers ! 

Highlighted
New Contributor II

Re: Multi-level pivot

Yes, the fields are in my data model. When I do a simple pivot, I am only seeing one level of columns, even though I add them both. I'm not sure how to "stack" them.

Highlighted
Contributor

Re: Multi-level pivot

Can you show in qlik how the pivot is looking like ?  

Did you also check the options in the presentation option - indented rows ?

View solution in original post

Highlighted
New Contributor II

Re: Multi-level pivot

Oh my goodness, this fixed my problem. It wasn't "indented rows," but I needed to click "fully expanded." I did not know where to look for this option, thank you so much!