Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Excel Export Format Issue

Hi,

How can i retain the same format while exporting to excel ? {Months{dimension} are in vertical rows in excel wheras in qlikview its horizontal column)

This is my qlikview report.

issue1.jpg

I am trying to export the same in excel.But the format is changed in excel as below:

issue2.jpg

4 Replies
Highlighted
Specialist
Specialist

Hi Poornima,

In Excel you will get the same format as you have specified in Chart.

You have to change the Dimensions and Expression in Chart to get the desired output.

rgds

Ashwani

Highlighted
MVP
MVP

You can try transpose  in excel like in screenshot below. Copy the content->Special Paste-> Transpose

transpose.png

Highlighted
Not applicable

we dont have any options in qlikview ?

i dont want to change the format in excel

Highlighted
MVP
MVP


While you are exporting from a qv object to excel, it takes the qv object format. Therefore if you choose to do it in qv, you have to create a chart of similar format and export from there. Otherwise, you might try to achieve the same using a more complex option, macro.