topic Re: Multiple selections in QlikView

Multiple selections

richard_chilvers — Thu, 11 Jul 2013 08:21:41 GMT

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

Re: Multiple selections

hic — Thu, 11 Jul 2013 09:37:59 GMT

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

Re: Multiple selections

er_mohit — Thu, 11 Jul 2013 10:17:39 GMT

see the attached file of AND mode list box

Re: Multiple selections

richard_chilvers — Thu, 11 Jul 2013 11:14:42 GMT

Thank you.

I have tried this and it works well.

I thought there might have been an easier solution though