Set Analysis

Fri, 25 May 2012 07:42:21 GMT

Hi All,

I have one issue in connection with SET Analysis, could you help me please?:

I would like to do sum of Total Contract Value in according to ContractNumber. How can I determine in layout per the SET Analysis, that if the Servicenumber (1000002926) + ServiceVersion (2) are the same for 2 (or more) ConctractVersions (2 and 3) it will consider only the Total Contract Value for the highest ContracVersion (if Servicenumber + ServiceVersion would be unique for each ContractVersion, it should be considered as well - 1000002927 +1, 1000002927+2).

Contract Number	ContractVersion	Servicenummer	ServiceVersion	Total Contract Value
1000001405	2	1000002926	2	100,00
1000001405	2	1000002927	1	200,00
1000001405	3	1000002925	3	300,00
1000001405	3	1000002926	2	400,00
1000001405	3	1000002927	2	500,00

So the result should be = 200+300+400+500=1300

Thank you very much in advance.

topic Set Analysis in QlikView

Set Analysis