topic Re: Set Analysys with date criteria's challenge in App Development

Set Analysys with date criteria's challenge

deerhunter — Tue, 20 Jun 2017 15:49:48 GMT

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'}

Thanks in advance

sunny_talwar — Tue, 20 Jun 2017 15:59:21 GMT

What is the format of StartDT?

sunny_talwar — Tue, 20 Jun 2017 19:05:10 GMT

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

sunny_talwar — Tue, 20 Jun 2017 19:09:21 GMT

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

deerhunter — Tue, 20 Jun 2017 19:20:36 GMT

< 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.

sunny_talwar — Wed, 21 Jun 2017 02:08:12 GMT

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

deerhunter — Wed, 21 Jun 2017 13:01:48 GMT

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