topic Re: PIVOT TABLE in QlikView

PIVOT TABLE

master_student — Wed, 25 Nov 2020 16:16:04 GMT

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 :

Thank you for your continued support.

avinashelite — Thu, 02 Jun 2016 11:30:52 GMT

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

Kushal_Chawda — Thu, 02 Jun 2016 11:31:05 GMT

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

master_student — Thu, 02 Jun 2016 11:39:51 GMT

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

I would like the result to be like that :

yasmeenk — Thu, 02 Jun 2016 11:51:33 GMT

Hi master_student,

Can you please say what is your exact need?

avinashelite — Thu, 02 Jun 2016 12:08:31 GMT

then i guess you need to manually expand all

trdandamudi — Thu, 02 Jun 2016 12:12:09 GMT

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

yasmeenk — Thu, 02 Jun 2016 12:17:37 GMT

Do it manually and save the report.

master_student — Thu, 02 Jun 2016 12:19:32 GMT

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

master_student — Thu, 02 Jun 2016 13:56:12 GMT

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

avinashelite — Fri, 03 Jun 2016 05:20:52 GMT

That's what the manual work we told