topic Re: Macro only for specific charts in QlikView

Macro only for specific charts

ajaykumar1 — Tue, 13 Oct 2015 07:10:43 GMT

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

Re: Macro only for specific charts

giakoum — Tue, 13 Oct 2015 07:15:50 GMT

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.

Re: Macro only for specific charts

ajaykumar1 — Tue, 13 Oct 2015 07:19:39 GMT

Thanks Ioannis for your quick resonse.

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

Thanks,

Ajay

Re: Macro only for specific charts

giakoum — Tue, 13 Oct 2015 07:24:24 GMT

Useful Qlikview Macros

Re: Macro only for specific charts

petter — Tue, 13 Oct 2015 08:40:53 GMT

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: