topic Change data sorting while exporting to excel in QlikView

Change data sorting while exporting to excel

v_jaideep — Sat, 16 Nov 2024 00:55:59 GMT

Hello,

I have a pivot table where data is show from Jan’19 to Dec’19 but when I export to excel I need data to be exported in reverse order that is Dec’19 to Jan’19, Dec’19 to be top on the excel. Is there any feasibility to implement in QV ?

Re: Change data sorting while exporting to excel

Anil_Babu_Samineni — Wed, 01 Apr 2020 11:17:24 GMT

Try If you allow Macro

Re: Change data sorting while exporting to excel

v_jaideep — Thu, 02 Apr 2020 12:18:51 GMT

Any other approches ?

Re: Change data sorting while exporting to excel

Brett_Bleess — Wed, 22 Apr 2020 21:16:14 GMT

To Anil's point, the only way I see to do this is via a macro using our APIs to change the sorting of the pivot table prior to doing the export via a button object. The only other way would likely be a macro in Excel to do it there...

Regards,
Brett