This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I have the task to show customers that have a contract with certain products.
Here a list of customers and their insurance contracts:
If I add 2 mandatory conditions on the product - everything works fine.
But if I will add the condition on the date of the contract ...
I’ll get this result:
But I don’t want to see John Lennon in final list because he did not have any agreements (with products KASCO & OSAGO for a given period 01.01.2014 – 03.04.2014.
I don’t know how to relate agreements and product list "ANDMODE". Does anyone have any ideas? without "set analysis"
In your application you are only filtering date-end. So this is correct behavior. You need to add more actions to filter date_begin also.
by the way... it's example only
To ask my question one date enough I think.
example or not this is your requirement :
To achieve it you need to filter date_begin also...
Ok, here we go...
"I don’t want to see John Lennon in final list because he did not have agreements with products KASCO & OSAGO ended in 01.01.2014 – 03.04.2014 period.
In my working model contract has more than 50 fields. And result of "AndMode" may be limited in any of these fields, as well as the date in this example.
aha so what you need is having BOTH products ending in that range and not just one...? Then you need set analysis to perform that task.
can I do it without "set analysis"? "set analysis" works very slowly on large queries in my model.
Page 119, QV reference manual. But you may need some data model changes to support it :
14.12 And-Mode in List Boxes
A multiple selection within a field is by default interpreted as logical OR, which means that data associated
to any of the selected field values will be shown in other fields. It is however possible to set certain list
boxes to And mode instead. When multiple selections are made in a list box set to And mode, the associations
in other fields must be to all selected values, which is exactly how associations are normally made
to multiple selections in several fields.
The mode for the field is set in List Box Properties: General tab.
When And mode is activated, an ampersand ("&") will be displayed in front of selected values.
If clicking and holding a value for a moment, the selection will switch from (AND) selected (green) to NOT
selected (red). The ampersand will also be replaced by an exclamation mark ("!"). The NOT selection which
is a forced exclusion of the value or values so marked, can only be made when a list box is in And mode.
Hope this will help!
field ANDMODE already added