Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How todisplay rows as columns in qlikview?

Hi All,

Can you please suggest me a way to display rows as columns?

eg: Input

Capture.PNG

to be displayed like : desired output

Capture.PNG

PS: values in fieldname

Capture.PNG

Thanks in advance.

1 Solution

Accepted Solutions
Not applicable
Author

Hi All,

Thanks for the response

I have done it using pivot table.

Thanks,

Simranjeet

View solution in original post

6 Replies
marcus_sommer

You could transform your data with a crosstable-statement: The Crosstable Load.

- Marcus

maximiliano_vel
Partner - Creator III
Partner - Creator III

In a straight table check the horizontal option in presentation

Horizontal.png

vardhancse
Specialist III
Specialist III

Hi,

We can get using cross table function as well

Anonymous
Not applicable
Author

Hi,

You can use cross table function to achieve your desired output.

Anonymous
Not applicable
Author

Hi,

Please follow this steps to achieve your desired output:

Step-1:Go to Edit Script and select the data source (Excel, CSV ...)

Step-2: Click on next button twice and after that click on CrossTable.

Above, you can select Qualifier fields, Name for Attribute Filed and Data Values. You can see the color combination with these related filed also. Press OK. Now Data is converted to Straight Table.

Now, Click on Finish.

Not applicable
Author

Hi All,

Thanks for the response

I have done it using pivot table.

Thanks,

Simranjeet