Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

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
Highlighted
Luminary
Luminary

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

Highlighted
Partner
Partner

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