topic Macro Syntax in QlikView

Macro Syntax

Wed, 17 Nov 2010 21:54:58 GMT

I have created a button to select a group of patients based on the following criteria using a macro created in the edit module:

sub Select72HourReturnsAnyDx

if field1 <= field2

select the row (patient)

else

ignore the row (patient)

end if

end sub

Would someone please help me put this in proper syntax?

Thanks,

Scott

Macro Syntax

pover — Wed, 17 Nov 2010 22:14:35 GMT

You can do this as an action in the button where you create a Select in Field action. The Field would be patient and the value can be an expression with an if (e.g. =if(field1<field2,'value').

If you want to do the macro look at APIguide.qvw that is located in C:/Program Files/QlikView/Documentation/ if you did a full install of QlikView Developer. There are plenty of examples to use to create your macro.

Regards.