Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Export to Excel With DateTime

Hello All,

Is it possible to export to excel the straight table or pivot table by just right clicking and send it to excel with datetime attached to It.

I have done using the macro but this time i need to just right click and send it to excel with date and time attached.

Thanks the help in advance

Talha

7 Replies
Highlighted
Partner
Partner

Export to Excel With DateTime

Sure, I do not see a problem. See enclosed. Or did I misunderstood your question?

Highlighted
Not applicable

Export to Excel With DateTime

Hello Rakesh,

I think i have not explained the problem properly. When i export the result of my chart (straight table or pivot table) to the excel i want all the data from the charts and in the end somewhere i want the date and time when this chart gets exported.This is cause the user exports a lot of charts and they want the date and time so that they can track when it got exported.

Thanks for helping me out, if you need more info then let me know, i will try to explain again

Talha

Highlighted
Not applicable

Export to Excel With DateTime

Is it not the name of the file created, something like CH01_20090918_142727.xls? That has the timestamp in the filename.

Highlighted
Not applicable

Export to Excel With DateTime

the only options seem to be adding the date as dimension or using the export selection stamp option, but a unique date would always have to be selected

Highlighted
Partner
Partner

Export to Excel With DateTime

Sorry Talha, I misunderstood. I don't think you can change anything with the export feature of QV, but you can certainly manipulate your charts to shouw this date/time somewhere somehow. See enclosed one example, where I have used "Total Label" field to populate this information. Now if your charts are using this field for other purpose, you will need to find some other way to show this in the chart somehow. I would be interest in knowing what you ended up doing. So please update here.

Highlighted
Partner
Partner

Export to Excel With DateTime

Hi Tom Mackay, This is correct.... wow! why didn't I notice that...

Highlighted
Not applicable

Export to Excel With DateTime

Hello Rakesh and Tom,

Yeh I know that when we export we get the date and time but the user is looking for that on the exported data sheet somewhere.I will let you guys know if i come up with some other options.

Thanks for all the time and help

Talha