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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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.