Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table

Hi All,

Can anyone tel is it possible to vertically expand and collapse the Dimensions in Pivot table?

5 Replies
Not applicable
Author

What do you need to do? explain a little more please!!!

pivot table.jpg

Anonymous
Not applicable
Author

Hi,

Omar is right, do you mean have your measures on the left and you dimension on top ? Or, do you want the table which looks like Omar's example ?

Quentin

Not applicable
Author

Hi Omar & quentin.bruno,

My example is simar to Omar's But In Omar's example dimensions are horizontally expand and Collapse and I need the same in verically.

see the attachments for Example

Anonymous
Not applicable
Author

Hi,

You can easily drag and drop your dimensions in your pivot table. You just have to go in your table properties then in the presentation tab and allow pivoting.

Next, just click on your dimension and drag and drop it wherever you want.

Quentin

Not applicable
Author

Hoooo I see!!! check the function CROSSTABLE maybe is what you need !!!!!! I make some examples with that function!!!! or you can UPLOAD some excel to look we can do....