Multiple selections

[richard_chilvers]

My table has records which are identified by an account code and the region code for that account.

I want to be able to select on some region codes together with some account codes not in those regions. This seems a straight forward OR selection, but forces me to work as a AND selection.

I look forward to some help.

Thanks

[hic · Accepted solution]

QlikView always works with an AND-logic between fields. But you can create OR-situations by creating a smart data model. Try the following, and you will get a selection field that you can use for OR-selections.

SourceData:

Load

   RecID,

   Region,

   Account

   From Source ;

SelectionField:

Load

   RecID

   'R: ' & Region as SelectionField

   Resident SourceData;

Load

   RecID

   'A: ' & Account as SelectionField

   Resident SourceData;

HIC

[er_mohit]

see the attached file of AND mode list box

[richard_chilvers]

Thank you.

I have tried this and it works well.

I thought there might have been an easier solution though