topic Re: Need to get Straight Table Row Count in QlikView

Need to get Straight Table Row Count

madhushi87 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to display a summary of employees who worked more than 61 hours per week in a straight table.

Below shows the details of employees.

I got worked hours using following query on the expression.

=if((Num#(Sum(if((Week(makedate(year(IN_DATE),month(IN_DATE),day(IN_DATE)))=Week(makedate(year(vMinDate),month(vMinDate),day(vMinDate)))),Interval(CHECK_OUTTIME-CHECK_INTIME,'hh'))))>=61)
=-1,Sum(if((Week(makedate(year(IN_DATE),month(IN_DATE),day(IN_DATE)))=Week(makedate(year(vMinDate),month(vMinDate),day(vMinDate)))),Interval(CHECK_OUTTIME-CHECK_INTIME,'hh'))))

But when i try to get the summary in another straight table it doesn't show as i expected. The expected results show as below.

I tried following query, can anyone please tell me what did i do wrong and how to get the correct count.

if((Num#(Sum(if((Week(makedate(year(IN_DATE),month(IN_DATE),day(IN_DATE)))=Week(makedate(year(vMinDate),month(vMinDate),day(vMinDate)))),Interval(CHECK_OUTTIME-CHECK_INTIME,'hh'))))>=61)
=-1,Count(DISTINCT EMPLOYEE_ID))

Thank You

Re: Need to get Straight Table Row Count

pradosh_thakur — Mon, 25 Mar 2019 11:32:41 GMT

sum(if((Num#(Sum(if((Week(makedate(year(IN_DATE),month(IN_DATE),day(IN_DATE)))=Week(makedate(year(vMinDate),month(vMinDate),day(vMinDate)))),Interval(CHECK_OUTTIME-CHECK_INTIME,'hh'))))>=61)
=-1,1,0))

Re: Need to get Straight Table Row Count

sunny_talwar — Mon, 25 Mar 2019 12:42:31 GMT

You can also try this

Count(DISTINCT
  {<
    [Employee Id] = {"=Num#(Sum(If(Week(IN_DATE) = Week(vMinDate), Interval(CHECK_OUTTIME - CHECK_INTIME, 'hh')))) >= 61"}
  >}
[Employee Id])

Re: Need to get Straight Table Row Count

madhushi87 — Tue, 26 Mar 2019 02:14:53 GMT

Thank you for helping me out. Really appreciate your support!!