topic Re: Selecting the same value in two fields - continued in QlikView

Selecting the same value in two fields - continued

Tue, 24 Mar 2015 13:42:24 GMT

Hi everyone,

I was recently given this awesome expression to sum Amounts for a value if it was present in either Field1 or Field2:

if(GetSelectedCount(Field1), sum({<Field1=p(Field1),Field2=>+<Field2=p(Field1),Field1=>}Amounts),

if(GetSelectedCount(Field2), sum({<Field2=p(Field2),Field1=>+<Field1=p(Field2),Field2=>}Amounts),sum(Amounts)))

However, I would like to create some variations on this. How do I write an expression that does the following:

- sum when the selected value is ONLY in Field1;

- sum when the selected value is ONLY in Field2;

- sum ONLY when the selected value is BOTH in Field1 and Field2.

Does anyone know how I can do this?

jonathandienst — Tue, 24 Mar 2015 14:38:11 GMT

You might be able to achieve this by changing the + sign (union) to * for intersection (BOTH) and - for exclude, like this:

<Field1=p(Field1),Field2=>-<Field2=p(Field1),Field1=>

<Field2=p(Field2),Field1=>-<Field1=p(Field2),Field2=>

<Field2=p(Field2),Field1=>*<Field1=p(Field2),Field2=>

HTH

Jonathan

Tue, 24 Mar 2015 16:23:37 GMT

It worked. Thank you!