topic Not able to get the intervel in the set expression in QlikView

Not able to get the intervel in the set expression

Mon, 16 Sep 2013 05:58:24 GMT

Hi Team,

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

(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

Re: Not able to get the intervel in the set expression

Gysbert_Wassenaar — Mon, 16 Sep 2013 08:11:21 GMT

Please read these two documents:

Re: Not able to get the intervel in the set expression

simondachstr — Mon, 16 Sep 2013 08:44:57 GMT

Maybe use COUNT(distinct IN_INCIDENT_NO)) ?

Re: Not able to get the intervel in the set expression

sbaldwin — Mon, 16 Sep 2013 10:39:11 GMT

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