topic Re: Pivot table, unfold automatically? in QlikView

Pivot table, unfold automatically?

Mon, 29 Dec 2014 09:54:54 GMT

Hi,

Merry Christmas to the whole community !!!

I have two questions.

First, with a pivot table, is it possible to hide symbols "+" and "-"?

Second, is it possible to unfold automatically a pivot table?

For exemple, i have this table :

I want this result but automatically (without clicking all "+")

Thanx for your help,

arulsettu — Mon, 29 Dec 2014 09:59:13 GMT

try in properties -> presentation -> enable always fully expanded

Mon, 29 Dec 2014 09:59:25 GMT

go to the properties of the chart and under presentation tab check the option "Always fully expended",it will expand the chart

Mon, 29 Dec 2014 10:03:48 GMT

Ok, thank you, i was sure that it was just an option, but i had not found it...

Thank you.

amit_saini — Mon, 29 Dec 2014 10:04:43 GMT

Hi,

Unfold you can control from here:

Presentation Tab-> Select your dimension or expression -> Check -Uncheck "Always Fully Expanded" option

I don't think so you can hide + and - in pivot table. Second option you can use straight table .

Thanks,
AS

Mon, 29 Dec 2014 10:17:03 GMT

Hi,

When I Check "Always Fully Expanded" from all fields, symbols "+" and "-" are hidden automatically.

amit_saini — Mon, 29 Dec 2014 10:20:44 GMT

Yes you are right.

Thanks,
AS