topic Re: Pivot table in QlikView

Pivot table

Tue, 16 Dec 2014 16:52:10 GMT

Hi all,

I am new to qlikview can anybody help me on the below task..

I am importing data from Sap tables the data in the table is like below

Material Material Group Calmonth Quantity

M1 MG1 Jan 10

M2 MG2 Feb 10

M3 MG3 Mar 10

I need to show the data in Pivot table as month wise

Jan | Feb | Mar

M1 MG1 10 M2 MG2 10 M3 MG3 10

Re: Pivot table

mato32188 — Tue, 16 Dec 2014 17:06:34 GMT

Hi kishore,

create pivot table with dimensions and expressions like usual and then drag and drop month dimension above your expression.

Re: Pivot table

richard_chilvers — Tue, 16 Dec 2014 17:15:04 GMT

Kishore

It depends how new you are to QV.

So to clarify, load the data as you describe. Then create a Chart, with Pivot Table style. Your dimensions with (probably) be Material, Material Group and Calmonth. Your expression will (probably) be SUM(Quantity).

When your pivot table is displayed you can 'drag' a dimension column up above the quantity column to create the display you look for.

Re: Pivot table

Tue, 16 Dec 2014 17:36:29 GMT

i am unable to drag the column above the expression column

i am trying to do this in after displaying the pivot table in sheet am i going correct way

Re: Pivot table

mato32188 — Tue, 16 Dec 2014 17:45:09 GMT

presentation tab - allow drag and drop, have you marked it?

Re: Pivot table

Tue, 16 Dec 2014 19:20:38 GMT

Hi Kishore,

please find the attachment.

I hope this will help you.