Macro only for specific charts

[ajaykumar1]

     Hi Everyone,

I need some help on writing the conditional macro. Daily am running my macro 2 times through windows scheduler .(with batch file creation).

Requirement : 1..when am run my macro first time it should go to users mail with only chart 1 and chart 2 only..Not the Chart 3.

2..When am run the second time only my chart 3 should export and save some where...No need to send any mail.

Here am attaching my sample application with macro.

Let me know if in case of any gap about the requirement.

More Thanks,

Ajay

[giakoum]

You could combine both in one and use a variable to check if it is the 1st or 2nd time the reload happens.

If variable = 0 then (1st time)

     variable = 1

     sent email

If variable = 1 then (2nd time and resetting the variable)

     export chart

     variable = 0 

That means that every 2 runs, it will export the chart.

[ajaykumar1]

Thanks Ioannis for your quick resonse.

Do you have any above mentioned code with you, that will be great help for me.

Thanks,

Ajay

[giakoum]

Useful Qlikview Macros

[petter]

By calling your QVW from Windows Task Scheduler and using QV.EXE command line parameters you can set variables that the application will use from the command line. Using those variables you can control which reports/charts are exported to Excel and whether they should be printed or not: