topic Qlik Expression in QlikView https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259367#M852205 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>I need to find the count of employees who are working between 3 to 7 hours. But it has to be changed when I select multiple months and years too. So, I had the below expressions,</P><P></P><P>count(DISTINCT Aggr(if(round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&lt;4,EmployeeID),EmployeeID)) - this is for employees working below 4 hours and</P><P></P><P>count(Distinct Aggr(if(round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&lt;8 and round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&gt;3 ,EmployeeID),EmployeeID)) - this one is for 3 to 7 hours</P><P></P><P>I got the first expression (&lt;4 hours) perfectly. But I couldn't get the second one (3 to 7 hours), I think the if condition I used is wrong somewhere, please correct it for me guys.......</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Qlik Expression https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259367#M852205 <HTML><HEAD></HEAD><BODY><P>Friends,</P><P>I need to find the count of employees who are working between 3 to 7 hours. But it has to be changed when I select multiple months and years too. So, I had the below expressions,</P><P></P><P>count(DISTINCT Aggr(if(round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&lt;4,EmployeeID),EmployeeID)) - this is for employees working below 4 hours and</P><P></P><P>count(Distinct Aggr(if(round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&lt;8 and round(sum(MonthlyWorkHour)/Count(DISTINCT MonthYear))&gt;3 ,EmployeeID),EmployeeID)) - this one is for 3 to 7 hours</P><P></P><P>I got the first expression (&lt;4 hours) perfectly. But I couldn't get the second one (3 to 7 hours), I think the if condition I used is wrong somewhere, please correct it for me guys.......</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259367#M852205 Anonymous 2020-11-25T16:16:04Z Re: Qlik Expression https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259368#M852206 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I do not see anything wrong with the expression.</P><P></P><P>Perhaps the expression is not returning anything</P></BODY></HTML> Fri, 24 Feb 2017 12:09:10 GMT https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259368#M852206 Anonymous 2017-02-24T12:09:10Z Re: Qlik Expression https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259369#M852207 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can you send sample data?</P></BODY></HTML> Fri, 24 Feb 2017 12:10:01 GMT https://community.qlik.com/t5/QlikView/Qlik-Expression/m-p/1259369#M852207 muthukumar77 2017-02-24T12:10:01Z