topic Re: Pivot table in QlikView

Pivot table

Wed, 13 Nov 2013 14:48:48 GMT

Hi All,

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

Re: Pivot table

Wed, 13 Nov 2013 16:11:08 GMT

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

Re: Pivot table

Anonymous — Wed, 13 Nov 2013 16:16:14 GMT

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

Re: Pivot table

Thu, 14 Nov 2013 07:55:54 GMT

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

Re: Pivot table

Anonymous — Thu, 14 Nov 2013 09:03:21 GMT

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

Re: Pivot table

Thu, 14 Nov 2013 13:37:57 GMT

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....