Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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