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