topic Re: Exporting graphs based on predefined selections in QlikView

Exporting graphs based on predefined selections

Anonymous — Fri, 29 Sep 2017 11:57:22 GMT

my requirement is to export a set of predefined graphs based on certain predefined selections. Is it possible to develop a macro that will trigger the export of these graphs after loading the file without the user actually making the selections in the list boxes.

User selections are fixed for generating this report every Monday. Can these be recorded and somehow be predefined as steps for exporting the graphs without the user actually opening the file to make selections and clicking on the button to export the graphs?

Currently I have developed a macro to export the graphs based on user selections. since the selections are also predefined can this also be defined in a macro without the user actually making these selections?

Re: Exporting graphs based on predefined selections

effinty2112 — Fri, 29 Sep 2017 12:01:13 GMT

Hi Sanjyot,

You could add a trigger on document opening to select a bookmark before running your macro to export.

Regards

Andrew

Re: Exporting graphs based on predefined selections

Anonymous — Fri, 27 Oct 2017 06:58:33 GMT

Hi Andrew

I need to export the same graphs with value 'A' and then value 'B' selected from the listbox.

Can I add a trigger on document opening that a runs a macro to export for 2 values? is it possible or is it possible only for one value?

Re: Exporting graphs based on predefined selections

Anonymous — Tue, 07 Nov 2017 07:04:58 GMT

Hi Andrew

I added a trigger on load of the document..It works now