Pivot Table with 1 Dimension and many measures

[#1]

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

Received

Qty Sold

Retur

Exchange

Adjustment

Reject

Sample

etc.

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

PLease advice.

Thanks

Henry

[petter]

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

[Josh_Good]

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

[petter]

Could you please mark this thread as answered as I believe there is a real answer to this for you in the thread