# Qlik Sense App Development

Contributor

## 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?

Tags (1)
6 Replies
MVP

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

What is the format of StartDT?

MVP

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

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

MVP

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

Contributor

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

MVP

## 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?

Contributor

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

Community Browser