topic Re: using macro variable value clear in QlikView

using macro variable value clear

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Using Macro how to clear multiple Variable values. Can anyone help me.

Frank_Hartmann — Tue, 21 Jun 2016 07:43:53 GMT

Try like this:

Function setVariable

set v=ActiveDocument.Variables("Variablename")

v.Forcecontent "0",1

END function

sasiparupudi1 — Tue, 21 Jun 2016 08:05:31 GMT

sub reset_vars

set doc=ActiveDocument

set vars = doc.GetVariableDescriptions

for i = 0 to vars.Count - 1

set v = vars.Item(i)

set v = nothing

set vars = nothing

set doc = nothing

end sub

not tested.. but should work

Regards

Sasi

Tue, 21 Jun 2016 08:18:18 GMT

Thanks for your reply Sasi,

My requirement is Multiple Variables i have.

For example :

I have three multi boxes and have three input boxes I want so like

Multiboxes : Multibox 1:, Multibox 2, Multibox 3

Input Box: input box1, input box 2, input box 3

When i give value in input box 1 = 10 show multibox 1, hide 2 and 3 multiboxes

and same as

input value is 20 show multibox2 and hide 3 and 1 multiboxes

and

input value is 11 show multibox3 and hide 1 and 2 multiboxes

Important things

i did using Conditional show , but properly not working.

See the attached file in above.

Can any one please help me as soon as possible. !

sasiparupudi1 — Thu, 07 Jul 2016 13:32:30 GMT

Please see the attached document