Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
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