One selection for multiple fields

[#1]

Hi,

A have a case where I have data like this:

Date	From	To	Amount
01-Apr	London	Belfast	£1
01-May	Birmingham	Edinburgh	£2
01-Jun	Belfast	Cardiff	£1
01-Jul	Cardiff	London	£3
01-Aug	London	Edinburgh	£2

I want to be able to select all transactions for a specific office using one List Box, i.e. if I select London (using either ‘From’ , ‘To’ or a generic list)  a Table Box would display the first, fourth and fifth rows of the above table.

I have looked at the solution using triggers (http://community.qlik.com/thread/53598), but this seems to depend on returning the field index or the ‘available’ options from the second field, neither of which satisfy my needs.

Could someone please tell me if this is possible, or do I have to select London twice (once from a ‘From’ List Box and once from a ‘To’ List Box) to return all the London rows.

Regards

Jason

[hic · Accepted solution]

You can add a second table in the script using

GenericCity:

Load From as City, TransactionID, 'From' as Type Resident Data;

Load To as City, TransactionID, 'To' as Type Resident Data;

and then use the field "City" for your selections. You do need a TransactionID, though, but this can easily be created in the first table using

RecNo() as TransactionID

HIC

[#3]

Henric,

I think I was over complicating it!

Thanks for your help.

Jason