Skip to main content
Announcements
Join us on Feb.12 to Discover what’s possible with embedded analytics: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paolojolly
Creator
Creator

Export horizontally straight table into excel

Hi, I'm not very experienced in QlikView and I need help to export a  Horizontally straight table into excel keeping the horizontal data. 

If I send this table to excel

paolojolly_0-1730365827821.png

by clicking XL button, on Chart caption I get

paolojolly_1-1730365900715.png

I can export to Excel and open the Paste Special dialog box, then select Transpose.... but my boss doesn't want to this way.

I cannot change chart type into pivot because I have a more complex chart that will use this solution.

Can someone help me?

Thanks

 

 

Labels (1)
12 Replies
marcus_sommer

Your table is a pivot and shouldn't be changed into a straight-table during the export. Take a look if you really export the right object and/or if there are any macros/actions/variables in place which may use another object or triggering a type-change.

Qrishna
Master
Master

I cannot open you qvw. You should be able to export the view as is into excel. you dont need to transpose in the excel.

 

you mentioned 'I cannot change chart type into pivot because I have a more complex chart that will use this solution.' but you are trying to export from pivot as seen from the picture.

David_Friend
Support
Support

what version of QlikView are you running?

Alan_Slaughter
Support
Support

@David_Friend What version of Qlik View is required?

paolojolly
Creator
Creator
Author

Hi, I'm using Qlikview 12.60(pretty old)

Thanks

paolojolly
Creator
Creator
Author

Hi, I'm using Qlikview 12.60(pretty old)

Thanks

paolojolly
Creator
Creator
Author

My table is a straight-table(I can't change the type of the graph otherwise I'll lose some straight-table properties)

Thanks

paolojolly
Creator
Creator
Author

Hi, I'm using Qlikview 12.60(pretty old)

Thanks

paolojolly
Creator
Creator
Author

Hi, I'm using Qlikview 12.60(pretty old)

Thanks