topic Re: pivot table in QlikView

pivot table

adiarnon — Sun, 29 Nov 2015 11:21:56 GMT

hi,

i have a pivot with 4 dimensions

i want that if i open the first dimension the second and the third will open

how can i do it?

Gysbert_Wassenaar — Sun, 29 Nov 2015 11:38:27 GMT

You can't. You can only expand/collapse all dimensions at once or manually expand each dimension value one at a time.

nagarjuna_kotha — Sun, 29 Nov 2015 11:42:30 GMT

Hi Adi ,

Its not possible

HirisH_V7 — Sun, 29 Nov 2015 12:23:42 GMT

Hi ,

I think one way is to include two dimensions at Backend ,

Customer & '-' &Product as New,

In Front end you can use this as a single dimension in Frontend,

Hope this helps as a way,

Thanks,

Hirish

settu_periasamy — Sun, 29 Nov 2015 13:17:32 GMT

May be like this you need?

=> 'Expand All' - for your 3 dimensions.(each dimension you should give 'Expand All')

=> In the First Dimension -> Give 'Collapse All' -> Save your app.

Now, if you click your 1st dimension, till 3rd dimension will open.

Not sure, this is your need. just i checked.

adiarnon — Mon, 30 Nov 2015 06:28:50 GMT

but it will change if the user will change the pivoting

right?

adiarnon — Mon, 30 Nov 2015 06:29:49 GMT

tnx,

and what about expression?

Kushal_Chawda — Mon, 30 Nov 2015 06:48:10 GMT

You can't do this. You can do expand & Collapse or expand the dimension one by one