Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

GetFieldSelections set analysis

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.

 

Field2Amounts
A10
B5
C2

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

Thanks!

1 Solution

Accepted Solutions

Re: GetFieldSelections set analysis

Hi Andrew, you can use this expression:

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

3 Replies

Re: GetFieldSelections set analysis

Hi Andrew, you can use this expression:

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

Employee
Employee

Re: GetFieldSelections set analysis

Check for function P()

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

Not applicable

Re: GetFieldSelections set analysis

Thank you both!