topic copy value in a variable in QlikView

copy value in a variable

Wed, 22 Sep 2010 08:58:37 GMT

Hello,
I need to copy the actual value of one field in a variable.

load * inline [
salesman , qty
paul , 10
peter , 50
Alan , 30

];

I put this values in a table

Now, if I select one Item in a table I would to copy the value of Salesman field
I selected in the variable . In this way I could to use the variable also ina a SQL
scrpt.
How to do this?

Thabk you .
Regards,

-
slash

copy value in a variable

Wed, 22 Sep 2010 09:56:42 GMT

if you create a variable vTest and put the value to field (=salesman) the variable will assume the field value when it is uniqely identified and null if it isn't

elsewhere if you want to have ever a value in variable you can use an aggragation value in variable (=Max(salesman))

copy value in a variable

Wed, 22 Sep 2010 10:06:15 GMT

Could you post the example file ?

The value of salesman myst be ? what I selected in a table.

Thanks for your support.

Regards,

Slash

copy value in a variable

Wed, 22 Sep 2010 10:24:57 GMT

copy value in a variable

Wed, 22 Sep 2010 10:43:03 GMT

Thanks but is not what I'm looking for to obtain.

Please look the example I attached in this post.

The value New is empty. I nedd tocopy the value in th variable by sql. look in the scrpt.

thanks

Regards,

Salsh

copy value in a variable

Wed, 22 Sep 2010 13:43:47 GMT

Maybe by Api ?

copy value in a variable

Thu, 23 Sep 2010 09:43:58 GMT

I attached a new file,

the variable is now built by API and I need to copi into a varable the value I selected.

When I press the button I verify the value of variable. Please someone could to complete the script?

I need to set the content ( what is selected in a field salesman.

Thankyou

Slash

copy value in a variable

Thu, 23 Sep 2010 10:04:15 GMT

Hi Slash,

Please check the attached file.

Help this one helps!

Regards,

Nadsky

copy value in a variable

Thu, 23 Sep 2010 10:37:16 GMT

Many Tahnks., but I add a "feature". I need the che is mad in the text object (

TX01 ) and not in a field . the value must be JUSt one selected. if I selct a null value the msgbox have to show "please select a value" .

find file in attachement

Tabk you

Slash

copy value in a variable

Thu, 23 Sep 2010 11:03:21 GMT

Please have you time to help me to add the features?

Many Thanks

Regards,

Slash

copy value in a variable

Thu, 23 Sep 2010 11:19:33 GMT

HI Slash,

Heres the updated one. This only select one salesman and has verification if no salesman is selected.

I use this code in OnSelect Action of Salesman.


=SubField(GetFieldSelections(Field), ',', 1)

Hope this solves your problem

Regards,

Nadsky

copy value in a variable

Thu, 23 Sep 2010 11:27:48 GMT

Just one thing:

you have insert this code in API:

SET selectedValue = ActiveDocument.fields("salesman"

).GetSelectedValues

But I need the value comes from a TEXT BOX andnot from a Salesman Field..

Many Thanks for you BEST support

Regards

Slash

copy value in a variable

Fri, 24 Sep 2010 08:21:20 GMT

Hi Nadsky,

the applicatio wascorrect but I need to capture a value from a text box.

I select a salesman the valueis copued in a text object and I put from a TBLE BOX to a variable and not from a field ?

Please, could to update the code?

Thnks so much

Regards,

-------------

Slash

copy value in a variable

Fri, 24 Sep 2010 08:54:08 GMT

Hi Slash,

Please use this macro code:


sub mySub

 Set myText = ActiveDocument.GetSheetObject("TX01")
 Set v = ActiveDocument.Variables("new")

 if myText.GetText = "-" then
 msgbox("Please select a value")
 else
 v.SetContent myText.GetText, true
 end if
 end sub

The variable now get its value from the value of the textbox.

Regards,

Nadsky

copy value in a variable

Fri, 24 Sep 2010 09:49:23 GMT

Are you sure of this line::

if myText.GetText = "-" then

it doesn't work

copy value in a variable

Fri, 24 Sep 2010 10:16:39 GMT

Yup.. if you don't select any customer from the list box the text value of Text Object is a dash (-)

Please see attached file. It works !