topic Programming Set Reference functionality with QlikView macros in QlikView

Programming Set Reference functionality with QlikView macros

cje — Wed, 16 Mar 2011 16:41:09 GMT

Good afternoon everyone,

I am really interested with the charts "Set Reference" functionality, very useful when you want to compare 2 situations corresponding to differnt selections on the same chart. As I can't use this functionality on iPad and Web browsers (not present in Menu icon and impossible to simulate the right-click from an iPad), I was wondering about programing this with VBScript or JScript and call it from a button with a "call module" action.

Anyone ever programmed this before?

Thanks in advance.

Regards.

Chris.

Programming Set Reference functionality with QlikView macros

cje — Thu, 17 Mar 2011 09:53:08 GMT

Here is the solution:

use a macro in the module (Tools/Edit module)

To set a reference:

...

Sub setReference

set Graph = ActiveDocument.getSheetObject("CH383")

Graph.SetReference

end sub

...

To Clear a reference:

Sub clearReference

set Graph = ActiveDocument.getSheetObject("CH383")

Graph.ClearReference

end sub

...

Then, call macros from a button action.

Chris