Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
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.