Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

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

6 Replies
sunny_talwar

What is the format of StartDT?

sunny_talwar

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

sunny_talwar

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

deerhunter
Creator
Creator
Author

< 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

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

deerhunter
Creator
Creator
Author

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