topic Re: Interval with Set analysis in QlikView

Interval with Set analysis

Fri, 17 Mar 2017 06:01:01 GMT

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

Re: Interval with Set analysis

tresB — Fri, 17 Mar 2017 06:07:35 GMT

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.

Re: Interval with Set analysis

Fri, 17 Mar 2017 06:13:46 GMT

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>

Re: Interval with Set analysis

tresB — Fri, 17 Mar 2017 06:18:47 GMT

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.

Re: Interval with Set analysis

Fri, 17 Mar 2017 08:34:50 GMT

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

Re: Interval with Set analysis

sunny_talwar — Fri, 17 Mar 2017 08:47:16 GMT

How about this may be

Interval(

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

'hh:mm:ss')