topic sum(if(Field1=Field2,Amount)) with set analysis in QlikView

sum(if(Field1=Field2,Amount)) with set analysis

blaise — Fri, 20 Nov 2009 21:16:54 GMT

How can i write a set analysis with the same result and behaviour as sum(if(Field1=Field2,Amount)).

With the set analysis i've tried I always need to select a value in either Field1 or Field2.

sum(if(Field1=Field2,Amount)) with set analysis

Fri, 20 Nov 2009 21:24:56 GMT

As far as I know (at least in 8.5) Set analysis cannot be used the way you want. Set analysis can only be used for one particular value (or more) but with named values.

IN the 9th version I know there is some new things regarding set analysis, but I'm not sure about that.

sum(if(Field1=Field2,Amount)) with set analysis

rwunderlich — Sat, 21 Nov 2009 02:24:37 GMT

Yes, V9 extends Set Analysis to allow selection based on another field.

-Rob

sum(if(Field1=Field2,Amount)) with set analysis

blaise — Tue, 24 Nov 2009 15:02:45 GMT

Yes, but what i found out i cannot be used as the provided example, only if there is selection within on of the two fields (field1, Field2)

sum(if(Field1=Field2,Amount)) with set analysis

Wed, 16 Dec 2009 20:01:33 GMT

I'm facing the exact same problem. Is there a definitive answer yet?

I was reading a similar discussion here. It gave the following solution to some problem:

SUM( { $ < ShipDate = {">=LaunchDate <$(=DATE(LaunchDate+35,'DD/MM/YYYY'))"} > } Quantity)

which is similar to the topic of this discussion. It was said to work but I have my doubts. The example presented in that discussion had only 1 distinct value for LaunchDate. Adding more rows with different values of LaunchDate broke the expression.