topic Re: Passing the QVW Filename into a Variable in QlikView

Passing the QVW Filename into a Variable

Tue, 16 Oct 2012 07:56:31 GMT

Hi there,

I have had a quick search and cant find a similar question (admitedly I might not be searching for the right thing)

Does anyone know of a way I can pass the name of the QVW file into a variable so that I can use it in the code editor.

My idea is to then use it in the WHERE clause of a section access load statement in order to give us the ability to restrict the results returned from a view to only those with a matchign report name, allowing us to grant access to individual reports without hundreds of text files or views.

If anyone knows of a way to pass this variable in, or knows of a better way to meet my objective, any help is greaty appreciated.

Thank you,

Chris

Re: Passing the QVW Filename into a Variable

Jason_Michaelides — Tue, 16 Oct 2012 08:01:18 GMT

Use the DocumentName() function:

LET vDocName = DocumentName();

Hope this helps,

Jason

Re: Passing the QVW Filename into a Variable

Tue, 16 Oct 2012 08:03:17 GMT

ok, so I was pretty stupid to ask... that one was actually quite obvious!

Thanks for your help! (again!)

Re: Passing the QVW Filename into a Variable

Jason_Michaelides — Tue, 16 Oct 2012 08:07:16 GMT

Not stupid at all.

Please mark the correct answer to close the thread.

Cheers,

Jason