Interval with Set analysis

[#1]

Dear All,

I want to calculate Time Difference only when the attendance is regularized.

Interval(EmpLogMinTime-InTime,'hh:mm:ss')

This gives me the time difference. But i need data only when IsRegularized=1

Tried Interval( {<Isregularized = {1}>} EmpLogMinTime-InTime,'hh:mm:ss') Showing some error.

Kindly help with this.

Regards,

Keerthi KS

[tresesco]

Try like:

If ( Isregularized = 1,  Interval( EmpLogMinTime-InTime,'hh:mm:ss') )

Set analysis can only be used with aggregation functions and interval() is not so.

[#3]

This works but isregularized with 0 also shows with null data. Need to show only with isregularized=1

Get Outlook for Android<https://aka.ms/ghei36>

[tresesco]

I guess you have to deal it with Null Suppression in the chart or Where clause in the script. Could you explain it bit more  - where, how... you are using it ? Screen shot, or sample qvw would help better.

[#5]

Please find the attached image. I need to calculate Time Interval only if isregularized is 1. Display only with Isregularized=1

[sunny_talwar]

How about this may be

Interval(

     Only({<Isregularized = {1}>} EmpLogMinTime-InTime),

'hh:mm:ss')