Bug? List box and a Conditional List box not respecting selections
I'll try to keep this simple.
What I Have:
QlikView 11.20.12904.0 SR12 64 bit
List box 1 = Category
List box 2 = Amount
List box 1 is a regular list box, nothing special here, 6 possible values.
List box 2 has an expression on the Amount field, specifying to show the field values based on a condition, STATUS. If(Status = X, Amount). This list box needs to have this condition as the list box is on a sheet within the report that only shows information with X status. In addition, there is an expression shown on the values of Amount to show a % of records. Within this expression, the same condition of Status = X is applied.
The Problem:
When I select a few values of Category, List Box 2 (Amount) should update and shown only associated values of Amount respective of the selected Categories AND respective of the conditional statement, Status = X. It is not. It ignores the selections in the List Box 1, I believe because the same condition on the Category Field is not applied. However, this is pretty basic and I expect Qlik to handle that.
What Doesn't Work:
- disabling the expression in List Box 2 to show % of records.
Instead of our If statement we tried set analysis and it worked. However, one drawback is that, values that aren't associated do not appear in the list at all, so it is a little bit different behavior than one might expect when used to "normal" list box functionality.
The application, should be built to respect the conditions either way though so the behavior for the user is the same.
Such behavior could only have two reasons. One is that there is no proper association between the three fields, second there is alternate state in use and both objects belonged to different states. Also any selections-triggers might have influence.
Instead of our If statement we tried set analysis and it worked. However, one drawback is that, values that aren't associated do not appear in the list at all, so it is a little bit different behavior than one might expect when used to "normal" list box functionality.
The application, should be built to respect the conditions either way though so the behavior for the user is the same.
