topic Re: How do I get selection values into an Excel Export filename? in QlikView

How do I get selection values into an Excel Export filename?

Wed, 19 Nov 2014 16:27:19 GMT

Hi, I have a button with an Export Action that exports data to CSV.

My main selection criteria is [Reporting Date] and I'd like the Export Action to name the file something like: myExport_20141119.csv where 20141119 is the current [Reporting Date] (I would need to format it to yyyyMMdd also).

How do I get a value from the current selection criteria into the file name of the export action settings?

The QlikView help says "If you export to a file you must mark this check box and enter the file name. If no file name is entered, the values will be exported to the clipboard. The file name may be entered as a Calculated Formula."

Trouble is, I'm a newbie and after searching this forum for over an hour, I can't find an example of this anywhere.

Re: How do I get selection values into an Excel Export filename?

morgankejerhag — Wed, 19 Nov 2014 17:00:14 GMT

Hello,
I haven't tried this myself, but I guess you could do something like

='myExport_' & date(ReportDate,'YYYYMMDD' & '.csv'

Are you sure that only a single ReportDate can be chosen when exporting? If it could be several ReportDates selected you will run into technical and logical problem with the above. To solve the technical part you can write:

='myExport_' & date(max(ReportDate),'YYYYMMDD' & '.csv'

But the logical problem persists - there are multiple reports merged and exported.

Re: How do I get selection values into an Excel Export filename?

Wed, 19 Nov 2014 17:07:16 GMT

You sir, are a ninja

thank you, works like a charm.