topic Re: Bug? List box and a Conditional List box not respecting selections in QlikView

Bug? List box and a Conditional List box not respecting selections

Thu, 01 Oct 2015 19:08:29 GMT

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.

- adding in syntax of "Amount=" to the expression on List Box 2 to show % of records (http://qlikviewcookbook.com/2015/02/listbox-expressions/)

Any help would be greatly appreciated!

Re: Bug? List box and a Conditional List box not respecting selections

marcus_sommer — Thu, 01 Oct 2015 20:38:17 GMT

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.

- Marcus

Re: Bug? List box and a Conditional List box not respecting selections

Fri, 02 Oct 2015 20:47:24 GMT

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.