topic Re: Pivot table similar to Excel in QlikView

Pivot table similar to Excel

Sat, 07 May 2016 14:38:14 GMT

I want to create Pivot table similar to Excel (as per attached s1.jpg). But it creates an additional column (as per attached s2.jpg).

See the heading "ShipCountry". Is it possible to create the PivotTable in qlikview similar to Excel Pivot.

Re: Pivot table similar to Excel

oknotsen — Sat, 07 May 2016 17:31:13 GMT

What you do is....

You create a chart -> Pivot table.

Select all the dimensions and expressions you want.

Click finish.

Expend all the columns.

Click on the dimension you prefer to have at the top and keep your mouse button down.

Move your mouse to the top-right of the chart and make a few circular motions. You will see a blue arrow show up the second you start dragging the column. Keep making those motions until it points left instead of up.

Now... let go of the mouse button and... tada... you got what you want .

Re: Pivot table similar to Excel

MindaugasBacius — Sat, 07 May 2016 17:52:27 GMT

Maybe Caption properties can work for you:

Only write down your Caption title as you wish.

Re: Pivot table similar to Excel

jonas_rezende — Sat, 07 May 2016 18:18:03 GMT

Hi, Deepak.

See the link below.

http://www.tutorialspoint.com/qlikview/qlikview_pivot_tables.htm

Hope this helps!

Re: Pivot table similar to Excel

trdandamudi — Sat, 07 May 2016 18:37:07 GMT

Please post a sample with data and we can create it for you.

Re: Pivot table similar to Excel

Sun, 08 May 2016 04:51:28 GMT

My requirement as per attached screen shot s11.jpg, where "Shipcountry" is displayed as header and it should be displayed as additional column (similar to what we have in excel pivot). But in qlikview I am able to move the "Shipcountry" horizontally (s21.jpg). But I am not able to move it as header and hide the additional column

Re: Pivot table similar to Excel

Anonymous — Sun, 08 May 2016 07:52:15 GMT

go to chart and select the select pivot table and give the two dimensions and expression than you get the pivot table

Re: Pivot table similar to Excel

jonathandienst — Sun, 08 May 2016 09:06:34 GMT

ShipCountry is not a new column, it is the label for the column headers. You can minimize the width of this column and optionally change the label in the dimension tab to a space. You cannot hide the item completely, but you can reduce its visual impact.

Re: Pivot table similar to Excel

Sun, 08 May 2016 15:07:49 GMT

Thanks for reply. Any example where we can minimize the width of this column and optionally change the label in the dimension tab to a space. I tried to add space for "ShipCountry" but it displays wrong result.

Also, can we change the "ShipCountry" as header (as per attached scree shot)

Re: Pivot table similar to Excel

muthukumar77 — Sun, 08 May 2016 15:34:39 GMT

Hi,

I hope this sample app is useful to you.

Please refer attached QVW

Re: Pivot table similar to Excel

Tue, 10 May 2016 02:49:41 GMT

Hi,

Thanks for your sample app. But can you also attach "Customers.qvd".

Re: Pivot table similar to Excel

muthukumar77 — Sat, 21 May 2016 13:43:03 GMT

no problem. you can attach your excel data same format instead of Customer qvd.