topic Conditional Run macro action? in QlikView

Conditional Run macro action?

Anonymous — Wed, 16 Sep 2015 11:40:44 GMT

Hi Experts,

Can we create action which Runs macro by using if statement and condition in it?

EX. I am using below statement while creating actions If(vNo_of_rows<5000,'ExportMacro')

I want my macro to run only when value of variable vNo_of_rows less than 5000.

Problem: It is still running macro when condition is False i.e. value is greater than 5000.

Thanks,

Nishant

Re: Conditional Run macro action?

tresB — Wed, 16 Sep 2015 11:46:56 GMT

Possibly the execution of your expression is not happening properly. Did you put '=' sign ? or may be $ expansion is required. Try like:

= If(vNo_of_rows<5000,'ExportMacro')

Or,

= If($(vNo_of_rows)<5000,'ExportMacro')

Re: Conditional Run macro action?

marcus_sommer — Wed, 16 Sep 2015 11:55:15 GMT

Maybe it's easier to include the condition within the macro itself instead in the trigger. You could query your variables within the macro like:

v = ActiveDocument.Variables("vNo_of_rows").GetContent.String

if v < 5000 then

export ...

else

msgbox "to many rows, please select ..."

end if

- Marcus

Re: Conditional Run macro action?

Anonymous — Wed, 16 Sep 2015 12:24:03 GMT

Tresesco,

I tried this but issue not resolved.

Thanks,

Re: Conditional Run macro action?

tresB — Wed, 16 Sep 2015 12:27:18 GMT

Have you checked your variable output? Could you post your problem qvw with sample reduced data?

Re: Conditional Run macro action?

Anonymous — Wed, 16 Sep 2015 12:31:21 GMT

Marcus,

This code change will always run macro only when value is <5000. I have a sheet from which I want to run same macro even when it is greater than 5000.

Actually, If it is <5000 I want to run Export to Excel. If it is greater than 5000 then I am showing warning msg (as Qlikview text object and not VBA msgbox) with continue button. If Continue is pressed then same macro will run.

Thanks,

Re: Conditional Run macro action?

Anonymous — Wed, 16 Sep 2015 12:39:33 GMT

Tresesco,

Yes I am monitoring variable which is counting the no. of rows. But somehow it is running macro even when variable has 5000+ number. I have also prioritize Set variable action first and below it I have run Macro on condition.

Thanks,

Re: Conditional Run macro action?

tresB — Wed, 16 Sep 2015 12:55:48 GMT

The problem could lie here in setting the variable value and excuting the macro in a same trigger. Try to remove the set variable action from the trigger and use a definition for the variable to get it's value.

Re: Conditional Run macro action?

PradeepReddy — Wed, 16 Sep 2015 13:15:34 GMT

try by removing the else part from the marcus solution...

Re: Conditional Run macro action?

marcus_sommer — Wed, 16 Sep 2015 13:15:36 GMT

The actions which are executed by one trigger won't be executed sequentielly - therefore is the suggestion from tresesco to separate these actions by from eachother depending actions recommended.

But your further requirements (from which sheet triggered and to react on the user-message) could be included into the macro. The calling sheet could be per getactivesheetid() assigned to another variable and a msgbox had a return-value for each button which will be pressed and which could be queried in another if-loop.

- Marcus