topic GetFieldSelections set analysis in QlikView

GetFieldSelections set analysis

Thu, 26 Mar 2015 18:16:34 GMT

Hi everyone,

I want to have an expression that sums all amounts where Field2 DOES NOT equal the current selection in Field1.

E.g. If A was currently selected, I would not want the first row included in the sum.

Does anyone know how to write the set analysis for this? I'm still struggling to learn.

Thanks!

rubenmarin — Thu, 26 Mar 2015 18:27:11 GMT

Hi Andrew, you can use this expression:

Sum({<Field2=Field2-Field1>} Amounts)

Clever_Anjos — Thu, 26 Mar 2015 18:28:55 GMT

Check for function P()

=Sum({<Field2-=P(Field2 )>} Amounts)

Thu, 26 Mar 2015 19:08:46 GMT

Thank you both!