topic Re: Pivot Table Dimensions to Expression in QlikView

Pivot Table Dimensions to Expression

settu_periasamy — Tue, 23 Dec 2014 08:20:19 GMT

Hi Team,

Find the below screen shot.

Source Data
Ctype	From	To	Product	Rate	Rec_No
NETP	5/31/2008	12/31/2015	BRND29707	6.85	1234
NETP	5/31/2008	12/31/2015	BRND29707	6.85	1235

In the Source data, Ctype, from, to , product and rate fields having same data. but the Rec_No is different. I need to make the single row for the product, Rate and Rec_No should be in the row field(Pivot table).

Thanks

Re: Pivot Table Dimensions to Expression

alkesh_sharma — Tue, 23 Dec 2014 08:54:20 GMT

Hello,

Please find the attached .QVW for your reference.

Re: Pivot Table Dimensions to Expression

Tue, 23 Dec 2014 08:58:16 GMT

Hi Settu,

click and hold on the dimension and then drag this up to the pivot location

hope that helps

Joe

Re: Pivot Table Dimensions to Expression

Wed, 27 May 2015 18:41:02 GMT

Any tips for someone struggling to "drag up"? I continue to select the dimension but the blue arrow continues to point upwards instead of sideways no matter where I drag it.

Also is there any way to do this without the dragging feature? In properties maybe?

Re: Pivot Table Dimensions to Expression

settu_periasamy — Thu, 28 May 2015 02:03:31 GMT

hi,

hope you aware, 'drag up' is possible in the pivot table only not straight table.

share the sample.

Re: Pivot Table Dimensions to Expression

Thu, 28 May 2015 08:00:27 GMT

No other way to do this I'm afraid. Select and hold the mouse button and you get the blue arrow, when you 'drag up' take your mouse first into the expression area (the red box) and then up into the expression labels(up the red arrow) and it should change to a sideways arrow for you.

You might need to keep dragging up beyond the labels and outside the chart. it can be a bit funny at times to register the movement.

hope that helps

Joe

Re: Pivot Table Dimensions to Expression

Sat, 30 May 2015 18:23:37 GMT

Gotcha. Thanks for the tip!