Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
MVP & Luminary
MVP & Luminary

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

- Marcus

maximiliano_vel
Partner
Partner

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

qlikviewnovice
Specialist II
Specialist II

Hi,

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

qlikviewnovice
Specialist II
Specialist II

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

View solution in original post