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

Selecting other list boxes using macros

Hi

I am recently adding a company field to an existing application.

I have the company linked to a supplier and a customers table.

Because of the way the application currently works, I can't simple link both tables to the same company table without getting a circular join 'thingy'.

I know there is a way (using macros) that if the user selects the company field on the customer, it will also select the same company on the supplier table.  Its been a long time since I had to do this, and can't remember how its done.

Thanks

Andy

1 Reply
Not applicable
Author

Hi,

Try sth like that:

Action, Select in Field, Choose your Field (Company)

In the search string : = replace( '(' & concat($ DISTINCT Company, '|') &')', ' ', '?')

Fabrice