topic Re: Run Macro on Object selection in QlikView

Run Macro on Object selection

ccsimo16 — Thu, 14 Apr 2016 07:20:33 GMT

Hi All

Hope this is posted in the right group.

I have Objects on my sheet designed as per customer required formatting. I then manually use a list box to select the customer, when exported, I then select the next Object and go back to the list box and select the next customer.

I would like to automatically select the list box when the Object has been selected. Is this possible with a Macro?

If this has been asked before, sorry must have missed the post.

Thanks for your help

Chris

Re: Run Macro on Object selection

Gysbert_Wassenaar — Thu, 14 Apr 2016 09:00:12 GMT

That's not possible. There is no event that fires when an object is selected.

Re: Run Macro on Object selection

Chanty4u — Thu, 14 Apr 2016 09:05:48 GMT

Hi,

AFAIK ,there is no such options.

Am no sure may be possible with macro or not?

Re: Run Macro on Object selection

avinashelite — Thu, 14 Apr 2016 09:51:54 GMT

Its not possible in Qlikview ....we don't have any event triggers for object selection

Re: Run Macro on Object selection

Kushal_Chawda — Thu, 14 Apr 2016 09:59:58 GMT

You can try this macro which automatically selects the listbox values in loop. In between you also use the export event for specific object see this

Loop through all filter values then print to PDF

Re: Run Macro on Object selection

marcus_sommer — Thu, 14 Apr 2016 11:19:59 GMT

If you want to export automatically you didn't need this kind of object-selection - you will simply loop through a list of object-id's and field-values, see for example these links:

VB Macro to Loop Field (Dynamic) and Export Chart (Dynamic) to Excel & Name Sheets by Field Value

Loop Charts and Field Values - Excel Export Macro

QlikTip #32: Exporting multiple QV objects to a single Excel document

- Marcus