https://community.qlik.com/t5/Management-Governance/Using-Monthstart-and-Monthend-for-hours-available/m-p/1964831#M22947 <P>It's quite hard to guess what your problem might be when you don't provide any sample data and you don't explain what the problem is, only that "the result is incorrect". What is the result? What would the expected result be given a set of sample data? Are you getting the expected value when you use each part of the expression separately or are one or more of them not the expected value? Also, are you sure you're correct in subtracting the first day of the month in the first half from the last day of the month in the second part? Wouldn't it be the other way around?</P> Thu, 04 Aug 2022 20:13:50 GMT Or 2022-08-04T20:13:50Z https://community.qlik.com/t5/Management-Governance/Using-Monthstart-and-Monthend-for-hours-available/m-p/1964809#M22945 <P>Hello everybody!</P> <P>I'm new to Qlikview and I have a question about how to calculate Available Hours for a service. In this case, I need to know the total number of hours available on the day of a service. I developed this expression:<BR />NR_EQP*24*MonthStart(MAX(DT_BUY_FIRSTDAY))- MONTHEND(MIN(DT_BUY)) AS HRS_AVAILABLE</P> <P>Where, NR_EQP is my equipment. 24 is the total hours and MonthStart(DT_BUY_FIRSTDAY) is the first day of the month. And, Monthend(DT_BUY) the last day of the month. But the result is incorrect.</P> Thu, 04 Aug 2022 18:48:53 GMT https://community.qlik.com/t5/Management-Governance/Using-Monthstart-and-Monthend-for-hours-available/m-p/1964809#M22945 lucasx15 2022-08-04T18:48:53Z https://community.qlik.com/t5/Management-Governance/Using-Monthstart-and-Monthend-for-hours-available/m-p/1964831#M22947 <P>It's quite hard to guess what your problem might be when you don't provide any sample data and you don't explain what the problem is, only that "the result is incorrect". What is the result? What would the expected result be given a set of sample data? Are you getting the expected value when you use each part of the expression separately or are one or more of them not the expected value? Also, are you sure you're correct in subtracting the first day of the month in the first half from the last day of the month in the second part? Wouldn't it be the other way around?</P> Thu, 04 Aug 2022 20:13:50 GMT https://community.qlik.com/t5/Management-Governance/Using-Monthstart-and-Monthend-for-hours-available/m-p/1964831#M22947 Or 2022-08-04T20:13:50Z