topic Re: Set value for mutiple variables in QlikView

Set value for mutiple variables

Mon, 12 Jan 2015 15:39:36 GMT

Hi All,

i'm looking for a tips to set a value for more then ten variables.

Now, i'm using a button with action 'set varaible' ten times not really good !!

thanks

Re: Set value for mutiple variables

Clever_Anjos — Mon, 12 Jan 2015 15:52:51 GMT

Are you setting same value to all of those variables?

Re: Set value for mutiple variables

Mon, 12 Jan 2015 15:55:25 GMT

Yep

Re: Set value for mutiple variables

Clever_Anjos — Mon, 12 Jan 2015 16:03:01 GMT

You could write a small macro to set all those variable, but using macros is usually a bad idea.

I would stay using 10 actions

Re: Set value for mutiple variables

Mon, 12 Jan 2015 16:13:52 GMT

hoo noo

i tried :

VAl1;VAL2;VAL3

VAl1,VAL2,VAL3

nothing works

Re: Set value for mutiple variables

jzimolong — Mon, 12 Jan 2015 18:36:09 GMT

Setup the vbscript macro below and assign to a button action
Make sure your variables have the same first few characters, like "vSet", so macro knows which ones to loop through
Click button, input the value you need to set, then it will loop through them all and set the value

Sub SetVariables

Dim objTempVar, objDestVar, objSourceVar, objSource
varValue = inputBox("Input your value")
varNo = ActiveDocument.GetVariableDescriptions.Count - 1

For i = 0 to varNo
     If Left(ActiveDocument.GetVariableDescriptions.Item(i).Name,4) = "vSet" Then
          set objTempVar = ActiveDocument.GetVariableDescriptions.Item(i)
          varname=Trim(objTempVar.Name)
          Set objSourceVar=ActiveDocument.Variables(varname)
          varcontent=objSourceVar.GetRawContent

Set objDestVar=ActiveDocument.Variables(varname)
objDestVar.SetContent varValue,true

END IF
Next

End Sub

Re: Set value for mutiple variables

Anonymous — Mon, 12 Jan 2015 20:37:31 GMT

I don't see anything wrong with multiple actions in one button... In most cases it is better than using macros.

Re: Set value for mutiple variables

jpapador — Mon, 12 Jan 2015 20:48:09 GMT

Since you are setting the same value you all variables you could just have the button set 1 variable and then have the other 9 variables equal that first one.

Re: Set value for mutiple variables

Tue, 13 Jan 2015 08:14:13 GMT

I agree, but when you have a lot of variables !! i've got a report with more then 24 variables.

Re: Set value for mutiple variables

Tue, 13 Jan 2015 08:15:34 GMT

it's sounds like greate !! i'll try this

Re: Set value for mutiple variables

jzimolong — Tue, 13 Jan 2015 11:05:12 GMT

I've attached my .qvw if it helps explain my solution above. Basically, it loops through each variable in the document and assigns the same value (based on input box) to those that begin with "vSet". You can play around with the syntax.

Re: Set value for mutiple variables

Tue, 13 Jan 2015 11:24:44 GMT

Thanks Joseph, but i dont need to put a value, i need to put 0 for all my variables. nothing more.

i changed you script to my needs

thanks again dude