topic Export data from access point to excel ? in QlikView

Export data from access point to excel ?

Tue, 20 Oct 2015 14:36:14 GMT

When i export data from qlikview access point to excel it was show all numerical's from left side but i want numerical's in right side.

In my application numerical's is right side and alphabetical are left side.
How can i do this could you please help me any one on this issue .

Please find below images.

1st image is from access point and 2nd image data export to excel from access point.

Thanks.

Lavanya

Re: Export data from access point to excel ?

Peter_Cammaert — Tue, 20 Oct 2015 14:45:07 GMT

As the export from the Access Point is done using HTML instead of a binary file, it will be pretty difficultl to fix this during the export itself. You can have a look in QV Desktop->Settings->User Preferences->Export in the top right area, but I don't think the Excel export settings offer you any solution.

You can always apply standard formatting to the column(s) in Excel. The number representations should match between QlikView and your local copy of Excel.

Peter