topic Re: How I get value from one variable to Other? in QlikView

How I get value from one variable to Other?

jsingh71 — Tue, 26 Feb 2013 06:42:09 GMT

Hi All,

Need your help !!!!!!!!!!!!!!!!!!!!!!

If I enter a name in 'Enter Name' Input Box and click on 'Save' button then name will display in 'Saved Names' Input box.

Again if I enter a second name and click on 'Save' button then both name will appear in 'Saved Names' Input Box. and so on How I got this??

qvw file attached....

Re: How I get value from one variable to Other?

Tue, 26 Feb 2013 09:07:20 GMT

are You sure You need to display Stored Names on inut box? Can't this be a table box?

Re: How I get value from one variable to Other?

jsingh71 — Tue, 26 Feb 2013 09:12:05 GMT

Yes i need to display these values from drop down list only. Because drop down list is not available in qlikview so my choice is InputBox only.

Re: How I get value from one variable to Other?

Tue, 26 Feb 2013 09:25:28 GMT

Hi Amit,

find the attached file, hope it helps

Re: How I get value from one variable to Other?

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

Thanx for reply yaseen.

the qvw file you shared, if I enter 'Yaseen' and click on Save button the Yaseen will display in Saved Name Input Box. its ok now I enter Qlikview in Enter Name and click on Save button then 'Yaseen' will disappear and only qlikview displayed. I want all names into Input box .

Re: How I get value from one variable to Other?

Tue, 26 Feb 2013 09:34:35 GMT

Hi,

The above code store only prest one.

If you want to store olders also use below code in Actions.

=vAvlName

'$(Name)'

Re: How I get value from one variable to Other?

jonathandienst — Tue, 26 Feb 2013 10:06:13 GMT

If I understand your need correctly, Actually Qlikview can do this for you.

Go to the Constraints tab on the properties for the Enter Name box. In the group named Value List, check the option List and set the number of recent values. The input box will now have a small 'drop down' icon at the right hand side. Clicking this will drop down a list of recently entered values.

Regards

Jonathan

Re: How I get value from one variable to Other?

jsingh71 — Tue, 26 Feb 2013 10:10:24 GMT

Hi Jonathan,

This I already done.

Actually the problem is :

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 get value from one variable to Other?

andy — Thu, 30 May 2013 07:03:57 GMT

Hi,

Maybe this helps.

In the macro you assign a value to a variable like this. (Create the variables before, vMacroMessage1 and vMacroMessage2)

sMessage = "Hello user from macro."

'Set variables to display text box

set v = ActiveDocument.Variables("vMacroMessage1")

v.SetContent sMessage,true

set v = ActiveDocument.Variables("vMacroMessage2")

v.SetContent "1",true

Then in you gui you can create two textobjects displaying the variables being set in the macro

/Andy

topic Re: How I get value from one variable to Other? in QlikView

How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

Re: How I get value from one variable to Other?

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

Re: How I get value from one variable to Other?

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