Discussion board where members can get started with Qlik Sense.
first time posting, but thanks for the great tips and advice I've received whilst lurking in the background
I'm using Sense v2, and I'm trying to get the name of the application that I'm running during the load script and add it to a variable.
I've tried different commands such as FileName, FilePath, but they relate more to the files that are being loaded.
I looked at DocumentPath, DocumentTitle and DocumentName as these do not relate to the data, but I guess I'm not getting the syntax right?
SET vDoc1 = DocumentTitle(); //Just gives "DocumentTitle()" in the variable
SET vDoc2 = $(DocumentTitle()); //Returns <NULL>
If any can help steer me in the right direction I'd be very grateful.
Go to Solution.
You need to use LET instead of SET:
LET vDoc1 = DocumentTitle();
(LET will do a calculation. SET will just make it whatever you have after the =.)
that's an awesome tip and thanks so much for the really quick response.
this worked - LET vDoc1 = DocumentTitle()
Woohoo, you just made my day.