6 Replies Latest reply: Jun 21, 2017 9:01 AM by Buck Master

# Set Analysys with date criteria's challenge

We have the following set analysys statements that return the same results?

Return a count where start date + 30 is = or greater then finish date:

Count ([WNUMBER]) - Count({< StartDT =

{">=\$(=num(date#(StartDT +30)) =>num(date#(FinishDT)))"} >} [WNUMBER])

Return a count where start date + 30 is = or less then finish date:

Count ([WNUMBER]) - Count({< StartDT =

{">=\$(=num(date#(StartDT +30)) =<num(date#(FinishDT)))"} >} [WNUMBER])

Can anyone see why?

Also, if i want to add additional criteria like: ,status={'C','P','A'}

• ###### Re: Set Analysys with date criteria's challenge

What is the format of StartDT?

• ###### Re: Set Analysys with date criteria's challenge

But where is StartDT, the field you are using in set analysis?

• ###### Re: Set Analysys with date criteria's challenge

But you are not using any of these in your set analysis... I am completely confused now...

• ###### Re: Set Analysys with date criteria's challenge

< 30 Days:

Count({< actstart =  {">=\$(num(actstart + 30,'###0') =<actfinish)"},worktype-={'PM','OC'} >} [wonum measure])

> 30 Days:

Count({< actstart =  {">=\$(num(actstart + 30,'###0') =>(actfinish))"},worktype-={'PM','OC'} >} [wonum measure])

Sunny here is a limited load qvf.

• ###### Re: Set Analysys with date criteria's challenge

I see a lot of KPI objects... which one am I looking at and what is the expected output here?

• ###### Re: Set Analysys with date criteria's challenge

mainly the two on the right, (< 30 days --> actstart/actfinish) &    (> 30 days --> actstart/actfinish).

Correcting those will help me see the error and correct the ones on the left to include your updates.

Thanks Sunny your a big help