topic Re: Using QV Variable in Macro in QlikView

Using QV Variable in Macro

Thu, 04 Jun 2015 13:50:03 GMT

Hi ,

I am using below code to assign the Qv variable value to temp variable in macro code but it is not working.

Full_Pack_ind is a AV variable and by default it is 'N'.

Set A1 = ActiveDocument.Variables("Full_Pack_Ind")

MSGBOX "Value Output" & A1

if A1 = "N" then

MSGBOX "High Level Export Complete!",VbInformation

end if

Can someone please help?

Regards,

alexandros17 — Thu, 04 Jun 2015 13:54:31 GMT

How to read and use a variable in macro:

...

set v = ActiveDocument.GetVariable("vRaw_WosF")
select case v.GetContent.String
case 1
v.SetContent "0",true

...

Thu, 04 Jun 2015 14:07:42 GMT

Thanks for your reply however it is not working for me.

Regards,

alexandros17 — Thu, 04 Jun 2015 14:19:27 GMT

Define a variable vvv as follow: LET vvv=1; then use this:

SUB AAA
set v = ActiveDocument.GetVariable("vvv")
v.SetContent "999",true
msgbox("Value Output " & v.GetContent.String)
END SUB

Mon, 11 Apr 2016 21:46:30 GMT

I have a Variable.

Example: vGraph = if(Graph='Line', CH01,

If(Graph='Bar', 'CH02')

vGraph is a QV variable.

I am trying to export the chart to excel and trying to implement the value of selection of graph here.

So instead of GetSheetObject(qvObjectId). Can i use ActiveDocument.GetVariable("vGraph ") in macro ??

Thanks in advance.