12 Replies Latest reply: Jan 23, 2016 9:48 AM by Petter Skjolden

# Pivot Table with 1 Dimension and many measures

Hi Guys,

in my report, I want to create report with 1 dimension and many measures from my stock card.

Example :

Measures                        jan        Feb      Mar      Apr ....

Beginning of Stock

Qty Sold

Retur

Exchange

Reject

Sample

etc.

I can't do it since table in QS measures in coloumn.

Thanks

Henry

• ###### Re: Pivot Table with 1 Dimension and many measures

A crosstable-pivot with a horizontal month-dimension and vertical measures are possible then in a pivot you could drag and drop dimensions and measures like you wished horizontal and vertical.

- Marcus

• ###### Re: Pivot Table with 1 Dimension and many measures

I am using JS pivot table extension, and there are 2 dimension and only 1 measure.

is there any pivot table extension which can many measures and 1 dimension ?

• ###### Re: Pivot Table with 1 Dimension and many measures

Use simply a normal pivot-chart.

- Marcus

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi Marcus,

Sorry I dont understand, normal pivot chart, is it bar chart n QS or another extension.

Because I cannot find that feature.

I just try with KFTable extension but also cannot solve my problem.

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi Henry,

I had a similar problem an maybe it is your solution ,

Regards,

Albert

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi

You have to write a single expression with multiple if conditions like

Dimensions : Measures, Month

Expression :

=If(Measure = 'Beginning of Stock', Sum([Beginning of Stock]),

If(Measure = 'Qty Sold', Sum([Qty Sold]),

...............................................

...............................................

)))))   (This is an example expression, you have to create your expression like this depends upon the number of measure you have)

Hope it helps you..

-- Ravikumar

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi Ravi,

Anyway I am not expert to create expression.

in my database, Beginning of stock, received are not in the same column, different table.

and when I am trying to write Measure and get error.

Could you please more spesific for this one ?

thanks a lot

• ###### Re: Pivot Table with 1 Dimension and many measures

this is exactly that I need

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi,

No problem , if you don't have measures in a single column then create a dummy column as below with sample data

Step 1:

A:

Katalok Short Name, QtySold, Reject, SalesHK, StockAwal

Kat 17, 10, 5, 100, 50

Kat 18, 15, 10, 500, 30

Kat 19, 20, 5, 1000, 50

Kat 20, 50, 45, 200, 100

];

Set vHidePrefix = _;

DummyTable:

_Dimension

QtySold

Reject

SalesHK

StockAwal

];

Step 2:

In a pivot table Use,

Dimensions : _Dimension, [Katalok Short Name]

Expression :

=If(_Dimension='QtySold', Sum(QtySold),

If(_Dimension='Reject', Sum(Reject),

If(_Dimension='SalesHK', Sum(SalesHK),

If(_Dimension='StockAwal', Sum(StockAwal)

))))

Step 3:

Note: Please do modifications accordingly as per the data you have.

Hope this is what you are looking for ..

-- Ravikumar

• ###### Re: Pivot Table with 1 Dimension and many measures

Actually you can do it in Qlik Sense - let Set Expressions do the job for you like you can see in the example App I made:

You can also do it with another method I have documented here: How to create a PIVOT table in standard Qlik Sense

• ###### Re: Pivot Table with 1 Dimension and many measures

Hi Henry,

You may want to take a look at the extensions available on Qlik Branch.  The JS Pivot is quite popular for pivot tables (note you will need to register before you can access it).

-Josh