topic calculate one way if date &gt;= else calculate a different way in QlikView https://community.qlik.com/t5/QlikView/calculate-one-way-if-date-gt-else-calculate-a-different-way/m-p/1383834#M421502 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate a field (Prod Per Hour) .&nbsp; If the date is &gt;= 3-1-2017 use this calculation, if its &lt; 3-1 use another calculation.</P><P>In doing so I can select the&nbsp;&nbsp; year,&nbsp; month or days.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I choose one month or day, I can get the correct results but if spanning months/days I can not.&nbsp;&nbsp; How can I get it to work with multiple selections?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179975_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 17 Oct 2017 17:07:25 GMT Anonymous 2017-10-17T17:07:25Z calculate one way if date >= else calculate a different way https://community.qlik.com/t5/QlikView/calculate-one-way-if-date-gt-else-calculate-a-different-way/m-p/1383834#M421502 <HTML><HEAD></HEAD><BODY><P>I am trying to calculate a field (Prod Per Hour) .&nbsp; If the date is &gt;= 3-1-2017 use this calculation, if its &lt; 3-1 use another calculation.</P><P>In doing so I can select the&nbsp;&nbsp; year,&nbsp; month or days.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I choose one month or day, I can get the correct results but if spanning months/days I can not.&nbsp;&nbsp; How can I get it to work with multiple selections?</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/179975_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Tue, 17 Oct 2017 17:07:25 GMT https://community.qlik.com/t5/QlikView/calculate-one-way-if-date-gt-else-calculate-a-different-way/m-p/1383834#M421502 Anonymous 2017-10-17T17:07:25Z