Logical help

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Manu

Re: Logical help

manu1512 — Mon, 15 Oct 2018 16:55:57 GMT