Not able to get the intervel in the set expression

[#1]

Hi Team,

Please suggest if there is some problem in the below expression, as im unable to get the desired result.

if

(CaseAge='>30' and (Interval((DayStart((Today()))-DayStart((INCIDENT_DATE))),'DD')>30),COUNT(IN_INCIDENT_NO))

i need to get the count of IN_INCIDENT_NO , if the number of days in difference between the dates is > 30 days...when executed the interval in a text object using max(incident date) it was giving me the correct result, but the same is not when used in set expression for a chart.

also INCIDENT_DATE is having multiple dates...Please suggest at the earliest...

Regards,

Hassan

[Gysbert_Wassenaar]

Please read these two documents:

1. QlikCommunity Tip: How to get answers to your post?
2. Preparing examples for Upload - Reduction and Data Scrambling

[simondachstr]

Maybe use COUNT(distinct IN_INCIDENT_NO)) ?

[sbaldwin]

hi, shouldn't you aggregate after applying the condition ie:

count   (   if(CaseAge='>30' and (Interval((DayStart((Today()))-DayStart((INCIDENT_DATE))),'DD')>30),IN_INCIDENT_NO)  )