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

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

Labels (2)
1 Solution

Accepted Solutions
AdiPai
Creator II
Creator II

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
AdiPai
Creator II
Creator II

Hi ! 

 

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

 

Cheers ! 

CreepyCatLady
Creator
Creator
Author

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.

AdiPai
Creator II
Creator II

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

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

CreepyCatLady
Creator
Creator
Author

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!