topic Re: Bookmarks and Macros in QlikView

Bookmarks and Macros

Mon, 27 Jul 2015 11:58:50 GMT

I have a report that uses a VB macro to turn on subtotals when a field is selected from another table. The bookmarks seem to bypass running the macro. Is this correct?

Re: Bookmarks and Macros

marcus_sommer — Mon, 27 Jul 2015 12:12:50 GMT

The best is to avoid macros - see Macros are Bad. In your case you could use your field twice one with subtotals and one without and each with a condition on your mentioned selected field - for this no macro will be needed.

- Marcus

Re: Bookmarks and Macros

Mon, 27 Jul 2015 12:18:13 GMT

The problem is that the field selected by the user is just a yes/no that kicks off a macro that uses an object to turn on partial subtotals for a category. I don't how to set that setting outside of a macro (other than at initial design).

Re: Bookmarks and Macros

marcus_sommer — Mon, 27 Jul 2015 12:26:01 GMT

Put your chart-dimension twice within the chart:

YourDimension // dimension-condition with subtotals: if(YourField = 'yes', true(), false())

YourDimension // dimension-condition without subtotals: if(YourField = 'no', true(), false())

- Marcus