topic Re: Macro to cycling variable value in QlikView

Macro to cycling variable value

Thu, 27 Apr 2017 07:08:21 GMT

Hi Qlikers,

i need a macro to change the variable value between two values (ex. 0 and 1).

I know that Qlik v11 has this option within the actions of the button.

This setting action fix the variable value as I want but I need to have the macro that make this job.

Thank you in advance!!!!

Re: Macro to cycling variable value

Anonymous — Thu, 27 Apr 2017 07:17:11 GMT

Hi ,

You can change the value dynamically after few seconds,

Try this-

Create variable

=if(second(now())>20,'1',if(second(now())>40,'2','3'))

Re: Macro to cycling variable value

Anonymous — Thu, 27 Apr 2017 07:20:45 GMT

Try something like in

How I assign macro variable value into qlikview variable???

Re: Macro to cycling variable value

Anonymous — Thu, 27 Apr 2017 07:22:47 GMT

=if(second(now())>40,'1',if(second(now())>20,'2','3'))

Re: Macro to cycling variable value

Thu, 27 Apr 2017 07:25:18 GMT

I've seen many Qlikers that propose this solution by time but I need to change on my own by a button or an input box.

Have any other ideas?

Re: Macro to cycling variable value

Anonymous — Thu, 27 Apr 2017 07:30:36 GMT

If the link i provided to use by macro, doesnt help you, you can aswell,

Create variable vVar,

Create button and add action in it to set variable value as If($(vVar)=1,0,1). It will alter the value every time you click the button

Re: Macro to cycling variable value

Thu, 27 Apr 2017 07:38:37 GMT

Unfortunately i have Qlik v8 and i can't upgrade it at this moment.

I've already done this action in Qlik v11 as you told me but now i have another Qlik version to manage.

I need have the macro that make this job.

Re: Macro to cycling variable value

Thu, 27 Apr 2017 08:11:12 GMT

I'm trying this VBScript:

Sub DispName

set Name1 = ActiveDocument.Variables("vName")

GetUserName = Name1.GetContent.String

if ( GetUserName = 0 ) then

tmpString = 1

else

tmpString = 0

end if

Name1.SetContent tmpString , true

End Sub

I want to set vName on 0 if the actual vName value is 1.

Everytime i want to fix the opposite value by button.

I don't know what there is wrong in this code to change the vName value.

Re: Macro to cycling variable value

Anonymous — Thu, 27 Apr 2017 08:29:07 GMT

Its working . am using Qlikview12. Nothing wrong with the VB script

Re: Macro to cycling variable value

Thu, 27 Apr 2017 09:01:11 GMT

I've tried in Qlik v11 and it works fine but it doesn't work in Qlik v8 .

I think that is a problem of VBScript of Qlik v8.

Thank you anyway!!!