Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I need to made different pdf export base of current day name (monday thursday ecc)
(because for monday on postreload i need to make many pdf export but the other day only one)
I made this command batch file to set different macro var exp_report = 0 , 1, 2 , 3 eccc
c:\progra~1\qlikview\qv.exe /r /vexp_export=0 "D:\Qlikview\test\test_036.qvw"
c:\progra~1\qlikview\qv.exe /r /vexp_export=1 "D:\Qlikview\test\test_036.qvw"
c:\progra~1\qlikview\qv.exe /r /vexp_export=2 "D:\Qlikview\test\test_036.qvw"
c:\progra~1\qlikview\qv.exe /r /vexp_export=3 "D:\Qlikview\test\test_036.qvw"
In qvw file i set exp_export variable
but i don't know how to write the macro to read and run as the exp_export var set by batch .
I try this but doesn't work:
if ActiveDocument.GetVariable("EXP_report").GetContent.string = "0" then
exit sub (to do no report)
if ActiveDocument.GetVariable("EXP_report").GetContent.string = "1"
(do only pdf report 1)
ActiveDocument.GetVariable("EXP_report").GetContent.string = "2"
(do report 1 ,2 3, 4, 5, 6, )
ActiveDocument.GetVariable("EXP_report").GetContent.string = "3"
(do all report )
Hi,
Hope this is of value to you. You will need to tweak it to fit into your needs, ut you can easily see it will show by day nameand later a time stamp by the hour. Not what you need - but just more along the same lines.
sub dateCheck
adate = activedocument.evaluate("date(today(),'wwww')")
if adate = "Sunday" then
msgbox(adate)
msgbox(hour(time()))
else
msgbox(time(today(),hh))
end if
End sub