Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do i Delete all variables at the time in Variable Overview Window?

Hi All,

I need to delete all variables in variable overview window without using neither SHIFT nor CTRL. By simply clicking button or event it should be deleted all variables in variable overview window. Can anyone help me out?

Thanks in advance

Gopi.P

4 Replies
vcanale
Partner - Creator II
Partner - Creator II

Try with a macro:

sub cleanVariables

  Set VariableDel = ActiveDocument.GetVariableDescriptions

  for i = 0 to VariableDel.Count - 1

  set tempVar = VariableDel.Item(i)

  tempVarName = tempVar.Name

  ActiveDocument.RemoveVariable tempVarName

  next

end sub

Not applicable
Author

Hi Vincenza,

Thanks for concern-reply. Still im struggling with the issue and attached my screenshot for your reference. Attached "QV Version" screenshot for whether macro can be used or not. Again thanks in advance...

Multiple variables deletion1.pngQV Version.png

vcanale
Partner - Creator II
Partner - Creator II

Hi Gopi,

this is a macro, you can't add it in the script.
CTRL+M and write the code I sent you in the Edit Module windows:Edit Module.png

Anil_Babu_Samineni

I request you to take backup first and then use. Sometimes, Clients need back up. So, Don't forget to back up with all variables and then reset using the Code which she provided

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful