Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Placement of Values in Pivot table

Hi All,

I have attached an Excel which has sample values like my application. I have 3 levels highlighted in column A. Can I achieve this in PIVOT or STRAIGHT TABLE. Currently it pivots one next to the other, I want it one below the other is that possible.? I am looking at it in this way because I want the values to be aggregated at all 3 levels. Thanks !!!

1 Solution

Accepted Solutions
sunny_talwar

I think the attachment did not come through. Can you reattach?

View solution in original post

5 Replies
sunny_talwar

I think the attachment did not come through. Can you reattach?

Not applicable
Author

Hi

Guess the attachment did not come through. I am resending it.

Thanks

Not applicable
Author

Hi Sunny,

Here is the attachment

Many Thanks

Not applicable
Author

Hi Sunny,

Hope you got the attachment.

Thanks in advance

Priya

sunny_talwar

You can use 'Indent Mode' on the Style tab of the Pivot table. Look here for similar disucssions:

Creating a Tree view in a Pivot table | Qlik Community

Using tree structure in the pivot table?

Create TreeView in Pivot Table | Qlik Community