topic Set expression return incorrect value. in QlikView

Set expression return incorrect value.

davoud-jelodar — Tue, 13 Sep 2022 10:45:32 GMT

I have a table with 3 fields, f1, f2 and value. the table is:

LOAD * Inline[
f1, f2, value
A , X , 1
A , Y , 1
B , X , 1
B , Y , 1
C , X , 1
C , Y , 1];

in qlikview I select f2 = X. the expression sum({$<f2={Y}>} value) return 3 instead of 0. In the picture you can see that. I don't know why?

Re: Set expression return incorrect value.

Or — Tue, 13 Sep 2022 11:04:06 GMT

This is correct and behaving as expected. f2={Y} means return rows where F2 is Y, and there are three such rows. This overrides any selection made on the field.

Re: Set expression return incorrect value.

davoud-jelodar — Wed, 14 Sep 2022 03:46:36 GMT

Thanks, but I selected f2=X then must be returned zero not 3. Your answer is correct if nothing selected. Notice that I use "$" sign (=active current selection) then sum must be 0.

Re: Set expression return incorrect value.

Heidenreich — Thu, 15 Sep 2022 03:44:53 GMT

As a test, I added a decimal variable and ran the same CASE expression against it and it works fine, returning the results as I would expect (rounding the value up when IsGun=1. But when I run that same CASE expression against another decimal value, it always returns the value with the CEILING() function and never returns the original value.

MyAccountAccess

may my info helpful

Re: Set expression return incorrect value.

tresB — Wed, 14 Sep 2022 06:14:00 GMT

Hello @davoud-jelodar ,

'$' is applicable for rest of the other fields which are not explicitly mentioned in the set. To achieve the behavior you are talking about, try using intersection operator, like below:

sum({$<f2*={Y}>} value)

Re: Set expression return incorrect value.

davoud-jelodar — Wed, 14 Sep 2022 06:49:40 GMT

Thank you