topic Re: Getting File Name from current file in QlikView

Getting File Name from current file

zagzebski — Fri, 18 Dec 2015 22:19:28 GMT

I want to read the name of the current file into my script, but it doesn't appear and of the "File" functions work.

All I want is something simple in my script like

Table1:

Load

FileName

RESIDENT Table;

In this case I want the "FileName" to simply return the name of the QlikView QVW I am using.

Re: Getting File Name from current file

petter — Fri, 18 Dec 2015 22:28:07 GMT

You can simply use the function DocumentName().

Re: Getting File Name from current file

zagzebski — Fri, 18 Dec 2015 22:30:20 GMT

Wow - how did I miss that?! Thanks.

Re: Getting File Name from current file

petter — Fri, 18 Dec 2015 22:31:48 GMT

A working example:

Table1:

LOAD

DocumentName() AS FileName

RESIDENT

Table;

Re: Getting File Name from current file

puneetagarwal — Tue, 09 Jan 2018 07:24:49 GMT

Hi Petter,

Can we get the caption name/window title as a filename while exporting the excel.

Eg: if we make a current selection as companyname like 'abc' the window title shows as abc_report, now i want the excel exported should take the name as abc_report.

Is it possible?

Regards,

Puneet