topic Re: How do you reference a variable passed as a ... in QlikView

How do you reference a variable passed as a ...

edwinmatlapeng — Sun, 29 Jan 2017 17:17:12 GMT

Evening All! How do you reference a variable passed as a parameter in a load script? Why is a long story suffice to say I want to create a qvd file for each flat file I load for other processes which will save us a lot of time and resources.

Re: How do you reference a variable passed as a ...

swuehl — Sun, 29 Jan 2017 17:37:32 GMT

If I understand you correctly, you reference this variable just like any other variable you create in the load script.

Starting QlikView ‒ QlikView

Script variables ‒ QlikView

Re: How do you reference a variable passed as a ...

edwinmatlapeng — Sun, 29 Jan 2017 18:10:29 GMT

Thank you for the response, Stefan. I appreciate that.

I think my problem then lies with my objShell.Run command. This is a part my batch file script from where I run objShell.Run. I am not sure if I need to assign the file name on the Run command or like I am doing. Also, can I assign the parameter like I am doing here?

qvdFileName = mid(sourceFile.Name,1,7) + ".qvd"

'Set ErrorCode = 0

Set objShell = CreateObject("WScript.Shell")

objShell.Run """c:\Program Files\QlikView\QV.exe /r /v" /vqvdFileName "C:\QlikView Working Area\QV Data\Other Files\QV1.qvw", 1, true

Can you see anything wrong, please?

Re: How do you reference a variable passed as a ...

edwinmatlapeng — Sun, 29 Jan 2017 18:37:51 GMT

I had to change the run statement. Got it to work. Thank you.

objShell.Run """c:\Program Files\QlikView\QV.exe"" /r /vqvdFileName="&mid(sourceFile.Name,1,7)&" C:\QlikView Working Area\QV Data\Other Files\QV1.qvw", 1, true