Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.

1 Solution

Accepted Solutions
avinashelite

then i guess you need to manually expand all 

View solution in original post

10 Replies
avinashelite

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

Kushal_Chawda

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

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