Skip to main content
Announcements
Qlik Community Office Hours - Bring your Ideation questions- May 15th, 11 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to execute a different report by macro when day busienss day change

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 )

1 Reply
Not applicable
Author

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