Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor II

AW:ReloadTime() in Excel export

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'

Community Browser