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
