Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need help in transpose

Hello everyone,

can you please help me to transpose this particuler col to transpose ( like the excel in the 2nd screen print ) and below that i need my inv qtyvalues

Qliksense current view

This col - current view.JPG

Need like this

Need like this.JPG

1 Solution

Accepted Solutions
jaumecf23
Creator III
Creator III

Hi,

First of all you need to use a Pivot Table. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

View solution in original post

4 Replies
jaumecf23
Creator III
Creator III

Hi,

First of all you need to use a Pivot Table. Then in the table, drag the date dimension header (you'll see a marker when you start dragging) to the top of the table, and the marker will change to horizontal. Drop it there and you will have a cross table.

Anonymous
Not applicable
Author

Hi Santosha,

You need use pivot table to achieve this requirement.

Thank you!

Best Regards,

Sumit kulkarni

Anonymous
Not applicable
Author

Thank you , it worked now.

Anonymous
Not applicable
Author

Thank you , it worked now.