Selecting other list boxes using macros

Wed, 20 Nov 2013 08:03:02 GMT

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

Re: Selecting other list boxes using macros

Wed, 20 Nov 2013 08:59:58 GMT

Hi,

Try sth like that:

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

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

Fabrice

topic Selecting other list boxes using macros in QlikView

Selecting other list boxes using macros

Re: Selecting other list boxes using macros