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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

PIVOT TABLE

Hello dear friends,

I need to use a pivot table, and I would like that all dimensions have by default the minus icon, How to do this?

Below a print screen of my table :

Capture.PNG

Thank you for your continued support.

Labels (1)
1 Solution

Accepted Solutions
avinashelite
MVP
MVP

then i guess you need to manually expand all 

View solution in original post

10 Replies
avinashelite
MVP
MVP

Go to chart properties >Presentation tab> Select Always fully expanded

Kushal_Chawda
MVP
MVP

pivottable-->rightclick-->-presentation-->always fully expanded option

master_student
Creator III
Creator III
Author

The pb, whene I do that the minus/plus icon will disappear, see bellow :

Capture.PNG

I would like the result to be like that :

Capture.PNG

yasmeenk
Partner - Creator
Partner - Creator

Hi master_student,

Can you please say what is your exact need?

avinashelite
MVP
MVP

then i guess you need to manually expand all 

trdandamudi
Master II
Master II

If you nee this way then you have to do it manually....

yasmeenk
Partner - Creator
Partner - Creator

Do it manually and save the report.

master_student
Creator III
Creator III
Author

Thanks, I i thought there's a more Quick solution   any way I need to create a new table style, do you know how?

Capture.PNG

master_student
Creator III
Creator III
Author

Hi guys, I find a solution, just right clik on the field name and click expand all :

Capture.PNG