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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Transform row to column

Hi All

Capture.PNG

I am trying to transpose row to column

I got output correctly but curious to as is this right way?

Capture1.PNG

Any other option ?

QV attached

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Well, you could change the field names:

T1:

CrossTable(Column, Month)

LOAD *  ...etc

Instead of a field named Value you would get a field named Month.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gysbert

Thanks for suggestion