topic Re: Pivot table in QlikView

Pivot table

vchuprina — Mon, 11 Jul 2016 20:29:02 GMT

Hi,

I expanded all columns and want to see following result in final application, but after reload I get another result (second screenshoot)

How expand all columns in pivot table?

Re: Pivot table

vishsaggi — Mon, 11 Jul 2016 20:34:03 GMT

In the presentation tab, check Always Fully expanded option and try.

Re: Pivot table

vishsaggi — Mon, 11 Jul 2016 20:35:41 GMT

Like in the image below:

Re: Pivot table

vchuprina — Mon, 11 Jul 2016 20:45:12 GMT

Hi vishsaggi,

I want have a opportunity to expand or collaps some lines

Re: Pivot table

vishsaggi — Mon, 11 Jul 2016 20:48:02 GMT

Sorry, I quite did not get your requirement, you want it to be fully expanded just as in first screen shot you have sent. Is that what you are looking for or something else?

Re: Pivot table

vchuprina — Mon, 11 Jul 2016 21:06:21 GMT

Yes, I want to see it fully expanded as in first screen shot

Re: Pivot table

vishsaggi — Mon, 11 Jul 2016 21:29:52 GMT

When you tried Always fully expanded what did you see, did it now fully expanded.

Can you share a sample qvw file if possible ?

Re: Pivot table

vchuprina — Tue, 12 Jul 2016 15:14:22 GMT

I got following result:

All data are expanded, but I can't collapse any columns

Re: Pivot table

vishsaggi — Tue, 12 Jul 2016 16:07:34 GMT

Sorry vchuprina, I have not seen any option to keep few expanded and few not expanded in pivot table. To my knowledge I am not sure if we have any work around for this as it is pivot chart property option to expand or not.

Try to post this again and see if any other experts can give any suggestions.

Thanks,
V.