Logical help

[manu1512]

Hi all,

I have a requirement to do in set analysis to count the equipment count.Requirement is as follows :

If the contract was active: IF ((contract start date <= D) AND  ((contract end date > D)

And

The equipment  (assumes always using is_Last_version = Y and equipment valid_to_date is always 31-dec-9999)

If IS_DELETED = N  and (equipment VALID_FROM_DATE <= D)

Then count as equipment covered by contract in D

If the contract was active: IF ((contract start date <= D) AND  ((contract end date > D)

And

The equipment (assumes always using is_Last_version = Y and equipment valid_to_date is always 31-dec-9999)

If IS_DELETED = Y  and (equipment VALID_FROM_DATE >= D)

Then count as equipment covered by contract in D

here D = MAX(DATEID)

I am new to qlikview.Please help me in this logic .

BR

Manu

[manu1512]

bpn‌