Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chriys1337
Creator III
Creator III

Expand Pivot Table in Qlik Sense to a intermediate Level

Hi,

 

I am having a Pivot Table with three Levels: Day, Date and Shift which are horizontally applied.

 

Now I would like to expand till the second, intermediate level which is Date (shift should be collapsed) and would like to have this as standard view when a user opens the application in the HUB. Is this possible?

With right click, I can just "collapse / expand all". Closed everything, just seeing the first level OR opening everything, seeing everything till the third level.

 

 

1 Reply
timpoismans
Specialist
Specialist

As far as I know, you can't achieve this with the standard pivot table in Qlik Sense. It's nothing or everything open.

There might be some extensions that would allow you to do this, but I don't know any.