Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
cje
Employee
Employee

Programming Set Reference functionality with QlikView macros

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.

1 Reply
cje
Employee
Employee
Author

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