Getting File Name from current file

[zagzebski]

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.

[petter · Accepted solution]

You can simply use the function DocumentName().

[zagzebski]

Wow - how did I miss that?! Thanks.

[petter]

A working example:

Table1:

LOAD

     *,

     DocumentName() AS FileName

RESIDENT

     Table;

[puneetagarwal]

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