topic Print variable value to msgbox in QlikView

Print variable value to msgbox

Tue, 22 Jul 2014 14:58:24 GMT

Hi,

I created a macro where i get a value from textbox to created variable. But if print it to msgbox i get an empty value though in variable overview i see that my variable get a value

what do i do wrong?

set Psum=ActiveDocument.GetSheetObject( "TX01" )

ActiveDocument.Variables("vPsum").SetContent Psum.GetText, true

suma=vPsum

msgbox("Sum is " &suma)

Thanks

Re: Print variable value to msgbox

m_woolf — Tue, 22 Jul 2014 21:06:23 GMT

Store the value in a vb variable something like this:

set Psum=ActiveDocument.GetSheetObject( "TX01" )

strAmt = Psum.GetText

ActiveDocument.Variables("vPsum").SetContent strAmt, true

msgbox("Sum is " & strAmt)

Re: Print variable value to msgbox

Wed, 23 Jul 2014 05:39:58 GMT

Hi,

Thanks it did the trick.

I wonder if it is possible to achieve the same result without using a variable vPsum just somehow get the object value straight in code