Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tigerbgs
New Contributor

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
Contributor III

Re: Need help in transpose

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.

4 Replies
jaumecf23
Contributor III

Re: Need help in transpose

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.

sumitkulkarni
New Contributor III

Re: Need help in transpose

Hi Santosha,

You need use pivot table to achieve this requirement.

Thank you!

Best Regards,

Sumit kulkarni

tigerbgs
New Contributor

Re: Need help in transpose

Thank you , it worked now.

tigerbgs
New Contributor

Re: Need help in transpose

Thank you , it worked now.

Community Browser