Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
richard_chilvers
Valued Contributor

Multiple selections

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

Tags (2)
1 Solution

Accepted Solutions

Re: Multiple selections

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

3 Replies

Re: Multiple selections

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
Honored Contributor II

Re: Multiple selections

see the attached file of AND mode list box

richard_chilvers
Valued Contributor

Re: Multiple selections

Thank you.

I have tried this and it works well.

I thought there might have been an easier solution though