topic Changing the sorting order for export only in QlikView

Changing the sorting order for export only

vlad_komarov — Wed, 10 Aug 2011 15:03:41 GMT

Hi all!

I have a chart that allows users to export the data to Excel.

I am using standard Ascending sorting there, and when the data is exported the result file looks like:

My question: is it possible to reverse the sorting for export only, so the August 2011 data will appear on top of the table?

Looking forward to suggestions and/or comments.

Best regards,

Vladimir

Changing the sorting order for export only

matt_crowther — Wed, 10 Aug 2011 15:21:36 GMT

The easiest way to solve this would be to craete a duplicate of the table, reverse the sort order then hide it. Add a button next to the current table ('Click to Export') that calls a macro that exports / sends to Excel the newly created hidden table.

You'll be able to find the Macro code in the API Guide that ships with Qlikview - if not simply search on the forum.

You could also create a macro that re-orders the table, exports it then re-orders it back to Asc again.

Hope that helps,

Matt - Visual Analytics Ltd

Changing the sorting order for export only

vlad_komarov — Wed, 10 Aug 2011 15:31:25 GMT

Matt,

Thanks for the suggestion.

It looks like I have only this option left (or I can try to convince the client to do re-sorting in Excel itself :-))).

Regards,

Vladimir