2 Replies Latest reply: Jan 14, 2014 5:54 AM by Jason Newman RSS

    One selection for multiple fields

      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