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: 
Not applicable

ReloadTime() in Excel export

Hi all!

I want to include the ReloadTime() in every export to Excel my user makes. I want to have it in a similar way as the Current Selections are included in the export (I've checked 'On BIFF exports' at User Preferences > Export > Selection Stamps in Exports).

I'm guessing I'll need a macro to do this, but this macro should be activated when an user uses the XL-button in the caption or 'Send to Excel'. Also, it should work at the AccessPoint where the default path for storing the temp file of the Excel export is different for each user.

Any ideas on how I can do this??

Thanks in advance for you replies!

1 Reply
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

there is an easy way to export every data you wish, put a dynamic expression in the label of your first dimension like:

='Reloadtime: '&Reloadtime()&'
Export
Label of your dimension'