topic Re: Name Excel export file in QlikView

Name Excel export file

sergio0592 — Wed, 03 Feb 2021 09:36:51 GMT

Hi all,

I'am looking for achiveve this :

-i have a chart (sales per country), eg when i select Country=Russia and export chart to Excel i d like to have the Excel file already named Russia.xlsx

Do you think it's possible? Thanks

Re: Name Excel export file

QFabian — Wed, 03 Feb 2021 19:23:48 GMT

Hi @sergio0592 , sure you can do that... with a macro, can you use them?

If yes :

https://qlikviewmacro.blogspot.com/2012/01/export-to-excel-macro.html

that macro do a few things and save it as the name of the selected value, just right here :

ActiveDocument.Fields("REGION").Select val.Item(i).Text
MyTable.ExportBiff path & val.Item(i).Text &".xls"

Re: Name Excel export file

sergio0592 — Thu, 04 Feb 2021 07:58:23 GMT

Thanks!!