Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

12 Replies
petter
Partner - Champion III
Partner - Champion III

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:

Pivot II.PNG

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

Josh_Good
Employee
Employee

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
Partner - Champion III
Partner - Champion III

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