Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

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

Thanks in advance

Tags (1)
6 Replies

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

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

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?

deerhunter
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