topic Re: Export horizontally straight table into excel in App Development

Export horizontally straight table into excel

paolojolly — Thu, 31 Oct 2024 09:16:25 GMT

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

by clicking XL button, on Chart caption I get

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

Re: Export horizontally straight table into excel

marcus_sommer — Mon, 04 Nov 2024 12:07:16 GMT

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.

Re: Export horizontally straight table into excel

Qrishna — Mon, 04 Nov 2024 16:57:03 GMT

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.

Re: Export horizontally straight table into excel

David_Friend — Mon, 04 Nov 2024 18:55:15 GMT

what version of QlikView are you running?

Re: Export horizontally straight table into excel

Alan_Slaughter — Mon, 04 Nov 2024 19:04:41 GMT

@David_Friend What version of Qlik View is required?

Re: Export horizontally straight table into excel

paolojolly — Tue, 05 Nov 2024 11:14:49 GMT

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

Thanks

Re: Export horizontally straight table into excel

paolojolly — Tue, 05 Nov 2024 11:15:01 GMT

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

Thanks

Re: Export horizontally straight table into excel

paolojolly — Tue, 05 Nov 2024 11:23:28 GMT

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

Thanks

Re: Export horizontally straight table into excel

paolojolly — Tue, 05 Nov 2024 11:24:18 GMT

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

Thanks

Re: Export horizontally straight table into excel

paolojolly — Tue, 05 Nov 2024 11:24:33 GMT

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

Thanks

Re: Export horizontally straight table into excel

David_Friend — Tue, 05 Nov 2024 19:45:50 GMT

eh while 12.60 is out of support its not terribly old, I just tried it in 12.90 and it also outputs to Excel but down the page 😞 I'm not aware of another solution besides what you already found 😞

Re: Export horizontally straight table into excel

Alan_Slaughter — Wed, 06 Nov 2024 19:01:30 GMT

Hi Paolo, maybe this will help:

To export a horizontal straight table to Excel while preserving the horizontal layout, you can follow these steps:

1. In the straight table properties, go to the Presentation tab and ensure the "Column Alpha" option is set to "Show Column".
2. Save the straight table and check if there are any hidden columns. If so, set them to be visible.
3. Once all columns are visible, right-click on the straight table and select "Export" > "Export Contents to Excel File".

By making all columns visible before exporting, the horizontal layout should be maintained in the exported Excel file.

Re: Export horizontally straight table into excel

paolojolly — Thu, 07 Nov 2024 06:28:58 GMT

Hi, I tried to follow your instructions, but they didn’t work. Did you try opening the qvw file in your computer?

If yes, can you get me back your qvw file?

Thank you