Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
see the attached file of AND mode list box
Thank you.
I have tried this and it works well.
I thought there might have been an easier solution though