topic Set analysis: Two Fields in a expression in QlikView

Set analysis: Two Fields in a expression

Thu, 19 Mar 2015 13:05:39 GMT

Hello:

I want that, an expression with the set analysis, don't apply the filters of two fields.

I want to do something like that:

SUM({$<Field1, Field2>} Sales)

SUM({$<Field1>}{$<Field2>} Sales)

But this expressions don't work

I know that with only one field, the expression goes well:

SUM({$<Field3>} Sales)

Thank you for your help

Roop — Thu, 19 Mar 2015 15:27:12 GMT

sum( {$<Field= {Value1, Value2}>} Sales )

sum( {$<Field1= {Value1}, Field2= {Value2}>} Sales )

Thu, 19 Mar 2015 15:45:11 GMT

Thank You Rupert;

I don't know how I try before, but reading your answer I tried another time this expression and its works :

SUM({$<Field1, Field2>} Sales)

Thanks,

Fernando