Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro Syntax

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



1 Reply
pover
Partner - Master
Partner - Master

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.