topic Re: Batch file execution based on condition in QlikView

Batch file execution based on condition

Kushal_Chawda — Thu, 27 Mar 2014 05:01:11 GMT

Dear All,

I am using the batch file for reloading the application.

Now I want to execute the batch file based on condition. When My Date not equal to System date batch file should not fire.

and email should go to respective managers saying that Date is not updated in the system due to application not refreshed.

else reload should go smoothly

Thu, 27 Mar 2014 05:26:17 GMT

If I'm being honest, DTS/SSIS is the easiest way of doing this.

Whilst it may be possible in QV, I'm pretty sure it's not straight forward..

vikasmahajan — Thu, 27 Mar 2014 05:28:22 GMT

Hii,

"C:\Program Files\QlikView\QV.exe" /VvTriggerMacro=0 "C:\Export-Email-Automation\Dashboard.qvw"

vTriggerMacro is variable can be pass thorugh batch file

SET v = ActiveDocument.Variables("vTriggerMacro")

varTrigger = v.GetContent.STRING

IF varTrigger = 1 THEN

Reload your application.

hope this helps you.

Vikas