topic Pivot Table in QlikView

Pivot Table

adiarnon — Sun, 03 Jan 2016 15:00:31 GMT

hi,

i have a pivot table with 4 dimensions:

SUPPLIER

ITEM

PURCHASE ORDER

PURCHASE DATE

BUYER

I want that i will have a + in the supplier and it will open the items

and the + in the items will open all the other dimentions

is there any option to do this?

tnx,

adi

Re: Pivot Table

Peter_Cammaert — Sun, 03 Jan 2016 15:06:29 GMT

Yes, if I'm not mistaken you can accomplish this behavior by walking the reverse path. It might take a while though, and your end-users will still be able to do whatever they want with your pivot table. It won't be a permanent pivot behavior. Except if you create a bookmark from the collapsed pivot and activate the bookmark whenever a user (re)visits the sheet.

Best,

Peter

Re: Pivot Table

Oleg_Troyansky — Sun, 03 Jan 2016 18:16:49 GMT

I think the need is caused by the fact that Purchase Date and Buyer are not true Dimensions in this case, but rather attributes that belong to the PO. This logic could potentially change if you change the sequence of the dimensions. For example, but placing Buyer before PO, you could group all POs for a specific Buyer.

Going back to the original requirement, you can solve it in a couple of ways (in addition to Peter's Suggestion):

1. Create a concatenated Dimension that includes a combination of a PO#, Purchase Date and a Buyer. This way, as soon as you open PO, you instantly see the PO Date and the Buyer.

2. Move PO Date and Buyer into Expressions, using the only() function. At the higher levels, multiple dates and multiple Buyers will likely be available, so the only() function will return NULL. At the PO level, both expressions will show the relevant attributes.

cheers,

Oleg Troyansky

Take your Qlik Skills to the next level at the Masters Summit for Qlik - now with new and redesigned materials!

Re: Pivot Table

HirisH_V7 — Mon, 04 Jan 2016 05:27:58 GMT

Hi ,

i think one way,

PFA,

HTH,

-HirisH