Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vlad_komarov
Partner - Specialist III
Partner - Specialist III

Changing the sorting order for export only

Hi all!

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

chart.png 

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

table.png

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

2 Replies
matt_crowther
Luminary Alumni
Luminary Alumni

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

vlad_komarov
Partner - Specialist III
Partner - Specialist III
Author

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