topic Re: condition in set analysis in QlikView

condition in set analysis

Fri, 09 Oct 2015 18:50:38 GMT

I have two fields. I want to write expression where field 1 values equal to field2. like sum the amount where field1=field2.

I tried sum({<field1 ={"field1=field2"}>}Amount) but not working

Kushal_Chawda — Fri, 09 Oct 2015 18:52:05 GMT

may be you missed '=', try

sum({<field1 ={"=field1=field2"}>}Amount)

maxgro — Fri, 09 Oct 2015 19:01:14 GMT

with field1 and field 2 as dimensions

sum(if(field1=field2, amount))

sunny_talwar — Fri, 09 Oct 2015 19:03:23 GMT

May be make the change in the script itself

LOAD field1,

field2,

If(field1 = field2, 1, 0) as Flag

FROM ...

and then use this:

Sum({<Flag = {1}>}Amount)

Fri, 09 Oct 2015 19:41:22 GMT

Try this one

sum({<field1 ={'=field1=field2'}>}Amount)

sum(if(field1=field2,amount))

Fri, 09 Oct 2015 20:15:41 GMT

Try this:

SUM(IF(Field1 = Field2, amount, 0))

Look for my QVW! !

Fri, 09 Oct 2015 20:18:57 GMT