topic Clear variables in QlikView

Clear variables

jagannalla — Tue, 26 Jul 2011 05:54:46 GMT

Hi,

Is there any macro code to clear particular variables(i.

Re: Clear variables

Miguel_Angel_Baeyens — Tue, 26 Jul 2011 07:42:45 GMT

Hi,

Can you please elaborate? Did you ceck the APIGuide.qvw file that is installed along with the documentation with the Full Install of QlikView Desktop? Did you check the SetContent member?

Set vVal = ActiveDocument.Variables("vVariable")
vVal.SetContent "", true

Do you want to completely remove the variable from the document? If so, did you check the APIGuide Application.RemoveVariable ?

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Clear variables

Tue, 26 Jul 2011 08:03:07 GMT

Hi,

you can use this:

sub cleanVariables

Set VariableCollection = ActiveDocument.GetVariableDescriptions

for i = 0 to VariableCollection.Count - 1

set tempVar = VariableCollection.Item(i)

tempVarName = tempVar.Name

'if left(tempVarName,3) = "tot" then

'msgbox "Deleting " & tempVarName

ActiveDocument.RemoveVariable tempVarName

'end if

end sub

Hope that helps!

Andrea

Clear variables

jagannalla — Tue, 26 Jul 2011 11:14:22 GMT

I'm using persona edition. I'm not able to open API quide.

Thanks for your help miguel.

Re: Clear variables

Miguel_Angel_Baeyens — Tue, 26 Jul 2011 11:42:52 GMT

Hi,

APIGuide.qvw is installed if you choose the Complete Install and should be personal edition available. If that's not the case, let us know so the QlikTech stuff around can take a closer look.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica