Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vchuprina
New Contributor III

Pivot table

Hi,


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

Без імені.png

How expand all columns in pivot table? 

Без імені.png

Tags (1)
8 Replies
vishsaggi
Esteemed Contributor III

Re: Pivot table

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

vishsaggi
Esteemed Contributor III

Re: Pivot table

Like in the Capture.PNGimage below:

vchuprina
New Contributor III

Re: Pivot table

Hi vishsaggi,

I want have a opportunity to expand or collaps some lines

Без імені.png
vishsaggi
Esteemed Contributor III

Re: Pivot table

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?

vchuprina
New Contributor III

Re: Pivot table

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

vishsaggi
Esteemed Contributor III

Re: Pivot table

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

Can you share a sample qvw file if possible ?

vchuprina
New Contributor III

Re: Pivot table

I got following result:

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

Untitled.png

vishsaggi
Esteemed Contributor III

Re: Pivot table

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.