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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro on gauge

Hi !

I've got 2 questions for everyone of you !

First : I want to get the value of a gauge, where a number is written by a LED. I go through a macro , and I have written this :

set eff_an = ActiveDocument.GetSheetObject("CH102")

But, then, I don't know what kind of getter I can use to put the result of the gauge into a variable. I've tried a GetText, a GetValue(s), but those methods don't exist. What should I write to get it ?

And the next question : where can I find a PDF, or something like this to know the properties of an Object ? Like in VBA, where the autocomplete shows every methods you can use on the type of object you use.

Thanks a lot !

1 Solution

Accepted Solutions
Not applicable
Author

I found it by myself, I put the solution here if someone in the future needs an answer

sub test

set eff_an = ActiveDocument.GetSheetObject("CH102")

ActiveDocument.Variables("effectif_an").SetContent (eff_an.GetTableAsText(false)),true

end sub

Your variable needs to be created before.

And if you've got decimals, change the decimal separator to '.' and not ','

View solution in original post

1 Reply
Not applicable
Author

I found it by myself, I put the solution here if someone in the future needs an answer

sub test

set eff_an = ActiveDocument.GetSheetObject("CH102")

ActiveDocument.Variables("effectif_an").SetContent (eff_an.GetTableAsText(false)),true

end sub

Your variable needs to be created before.

And if you've got decimals, change the decimal separator to '.' and not ','