topic Re: How do i Delete all variables at the time in Variable Overview Window? in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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

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

vcanale — Mon, 17 Oct 2016 16:07:58 GMT

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

end sub

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

Tue, 18 Oct 2016 04:46:26 GMT

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...

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

vcanale — Wed, 19 Oct 2016 08:16:50 GMT

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:

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

Anil_Babu_Samineni — Wed, 19 Oct 2016 08:46:47 GMT

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