topic Re: Set Analysis variance between 2 fields in QlikView

Set Analysis variance between 2 fields

alan_grn — Wed, 07 Jan 2015 14:54:57 GMT

I am trying to write set analysis for the following :

Sum Sales where Field1 > 0, Field2 > 0 and Field1- Field<0

I can get the first 2 pieces to work but when I try Field1-Field2={'<0'} I get no values

Anonymous — Wed, 07 Jan 2015 15:08:26 GMT

You can try Field1 ={"<$(Field2)"}, that is the same of Field1-Field2<0

alan_grn — Fri, 09 Jan 2015 12:51:07 GMT

Thanks

Field1 ={"<$(Field2)"},

but I also need where Field1 > 0.

Sum({< Field1 ={">0"},Field2={">0"},Field1 ={">$(Field2)"} >} Sales)

My code above works but I think that this give me where Field1 > 0 or > field2. How do I change this to and?

I need where Field1 > 0 and field1 >Field2

Anonymous — Fri, 09 Jan 2015 12:57:06 GMT

You can use intersection "*", for example:

Sum({< Field1 ={">0"}, Field2 ={">0"}>*<Field2 ={">0"},Field1 ={">$(Field2)"}>} Sales)

or something like this..