topic Re: How I assign macro variable value into qlikview variable??? in QlikView

How I assign macro variable value into qlikview variable???

jsingh71 — Tue, 26 Feb 2013 09:25:19 GMT

I created two qlikview variables 'vName' and 'vAvlName'.

through macro I am getting the value from qlikview variable 'vName'.

Sub DispName
set Name1 = ActiveDocument.Variables("vName")
GetUserName = vName.GetContent.String
End Sub

Now in 'GetUserName' variable i got the value.

Now I want to assign this value to qlikview variable 'vAvlName'.

How can I assign this value from macro to qlikview variable.

Please help.........

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 10:19:19 GMT

Hi Amit,

It is as simple as following :

Sub DispName

set Name1 = ActiveDocument.Variables("vName")

set Name2 = ActiveDocument.Variables("vAvlName")

GetUserName = Name1.GetContent.String

Name2.SetContent GetUserName , true

End Sub

Best regards - Peyman

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 10:21:15 GMT

please notice that vName is not correct and you need to use Name1 instead.

GetUserName = vName.GetContent.String

Re: How I assign macro variable value into qlikview variable???

jsingh71 — Tue, 26 Feb 2013 10:35:17 GMT

Thanx for your reply.

but this was not a correct answer which i am looking.

Actually I have 'vName' qlikview variable and one more 'vAvlName' qlikview variable.

I am getting vName value through Macro and want to assign this value into qlikview variable 'vAvlName'.

Re: How I assign macro variable value into qlikview variable???

devans_1 — Tue, 26 Feb 2013 10:40:39 GMT

Try:

GetUserName = ActiveDocument.Variables("vName").GetContent.String

ActiveDocument.Variables("vAvName").SetContent GetUserName, True

David

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 10:45:40 GMT

That is exactly what this macro do. Please use my code in your madule and test it yourself. I'll post an example QVW asap.

Best regards - Peyman

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 10:52:31 GMT

hier is the example.

Re: How I assign macro variable value into qlikview variable???

devans_1 — Tue, 26 Feb 2013 10:53:16 GMT

Yes, it is basically the same as what you wrote Peyman. I think it should work. I have used similar code on many occasions and never had a problem.

Re: How I assign macro variable value into qlikview variable???

jsingh71 — Tue, 26 Feb 2013 11:11:01 GMT

Thank you very much Peyman and David.

Please refer VARs.qvw

one last thing I want to know then I mark this disscussion as Answered.

Suppose first I enter name 'Qlik' and clik on button then 'Qlik' will display in text object.

Now I enter 'View' and when I click on button then I want Qlik, View as displayed in Text box.

How I concatenate previous word into new word??

Re: How I assign macro variable value into qlikview variable???

devans_1 — Tue, 26 Feb 2013 11:23:42 GMT

Try:

GetUserName = ActiveDocument.Variables("vName").GetContent.String

CurrUserName = ActiveDocument.Variables("vAvName").GetContent.String

NewUserName = GetUserName & "," & CurrUserName

ActiveDocument.Variables("vAvName").SetContent NewUserName, True

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 11:24:12 GMT

ok, please wait a minute, i will update the qvw.

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 11:31:37 GMT

Sub DispName

set Name1 = ActiveDocument.Variables("vName")

set Name2 = ActiveDocument.Variables("vAvlName")

GetUserName = Name1.GetContent.String

GetOldUserName = Trim(Name2.GetContent.String)

if ( GetOldUserName <> "" ) then

tmpString = GetOldUserName & "," & GetUserName

else

tmpString = GetUserName

end if

Name2.SetContent tmpString , true

End Sub

Re: How I assign macro variable value into qlikview variable???

jsingh71 — Tue, 26 Feb 2013 11:56:37 GMT

Thanx a lot both of you...

both answers are correct

Re: How I assign macro variable value into qlikview variable???

azimabadi — Tue, 26 Feb 2013 11:58:31 GMT

glad this helped

Re: How I assign macro variable value into qlikview variable???

Fri, 28 Mar 2014 04:38:09 GMT

Hi,

I wrote the macro code for a button to get the current selection in listbox .Like this

SUB GetSelectedValues

SET id= ActiveDocument.Fields("V_Id")

SET selection = id.GetSelectedValues
if selection.Count=1 then

msgbox(selection(i).Text)

end if

END SUB

When I click the button ,I need to store the macro variable ( selection) to a qlikview variable which I'll use later in load/select query in edit script.For example if I assigned the macro variable (selection) to a qlikview variable(say 's'),then the select query would be like this.

select * from table1 where V_Id=$(s);

suggest me a correct prodecure in assigning macro variable to qlikview variable.

Please help me in solving this.Thanks!!

Re: How I assign macro variable value into qlikview variable???

Thu, 21 Aug 2014 11:02:53 GMT

Hi,

Your Post was very useful, Thanks.

But I wanted to ask one thing, suppose if I want to retrieve the latest appended value to the variable how can I do So?

In order to print it in text Box

Thanks in Advance

Re: How I assign macro variable value into qlikview variable???

Thu, 21 Aug 2014 11:04:10 GMT

Hi,

What if suppose I want to retrieve the latest appended value to the variable how can I do So?

In order to print it in text Box

Thanks in Advance

Re: How I assign macro variable value into qlikview variable???

bluecarbon — Fri, 04 Mar 2016 16:45:42 GMT

Hi Peyman,

Please let me know what is ShownValue.String property of a variable? I m able to get Raw Value of a variable as the expression used in that variable, but I always get ShownValue as empty.

Thanks,

Rakul.

Re: How I assign macro variable value into qlikview variable???

vladimir_f — Wed, 15 Feb 2017 14:06:23 GMT

Hi!

Can you help me too?

my script like that:

**************************

SUB sd3
ActiveDocument.Variables("_sf00").SetContent 0, True
ActiveDocument.Variables("_sf01").SetContent 0, True
ActiveDocument.Variables("_sf02").SetContent 0, True
ActiveDocument.Variables("_sf03").SetContent 1, True
ActiveDocument.Variables("_sf04").SetContent 0, True
ActiveDocument.Variables("_sf05").SetContent 0, True
ActiveDocument.Variables("_sf06").SetContent 0, True
ActiveDocument.Variables("_sf07").SetContent 0, True
ActiveDocument.Variables("_sf08").SetContent 0, True
ActiveDocument.Variables("_sf09").SetContent 0, True
ActiveDocument.Variables("_sf10").SetContent 0, True

END SUB

**************************************

that Macro working fine... but... i need somehow to stop action History reccording at the start of macro...

because as a result, the button 'Back' stops working.. actually working.. but not properly..

for come to last step (before i used Macro), i need to push "BACK" button 11 times (for each setContent in my macro)

Do you know how to solve this problem?

topic Re: How I assign macro variable value into qlikview variable??? in QlikView

How I assign macro variable value into qlikview variable???

Sub DispNameset Name1 = ActiveDocument.Variables("vName")GetUserName = vName.GetContent.StringEnd Sub

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Re: How I assign macro variable value into qlikview variable???

Sub DispName
set Name1 = ActiveDocument.Variables("vName")
GetUserName = vName.GetContent.String
End Sub