Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

.vbs/.Bat and Qlikview

Hi Guys

I want to set the value of the variable in qlikview document using .vbs file or .bat file .  i am using the following script and it is working fine  but it opening the qlikview doc . i want to avoid opening of qlikview doc ..... is it possible to do without opening the qlikview doc set the value of the variable in .qvw.

.

-------------------------------------------------------------------------------------------------------------------

Set QV = CreateObject("QlikTech.QlikView")

Set f = QV.OpenDoc("C:\Users\Administrator\Desktop\Do Not Delete\Automation_Report2.qvw")

Set variable = f.GetVariable("vMessage")

variable.SetContent "Done",True

QV.Quit

1 Reply
Not applicable
Author

if ur lookig for shcedular create a .bat file using the follwing code in notepad

"C:\Program Files\QlikView\QV.exe"

/r "D:\Pathname\filename.qvw"

then set the windows shcedular in task manager