topic Re: Week function not working when year changes. in QlikView https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61263#M10243 <HTML><HEAD></HEAD><BODY><P>Can you share your data or app?</P></BODY></HTML> Thu, 08 Mar 2018 19:07:55 GMT isingh30 2018-03-08T19:07:55Z Week function not working when year changes. https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61262#M10242 <HTML><HEAD></HEAD><BODY><P>I use the Week function to get the week difference between dates but as the year changed I started facing problems. Can anyone help me with this?</P></BODY></HTML> Tue, 06 Mar 2018 19:45:44 GMT https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61262#M10242 Anonymous 2018-03-06T19:45:44Z Re: Week function not working when year changes. https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61263#M10243 <HTML><HEAD></HEAD><BODY><P>Can you share your data or app?</P></BODY></HTML> Thu, 08 Mar 2018 19:07:55 GMT https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61263#M10243 isingh30 2018-03-08T19:07:55Z Re: Week function not working when year changes. https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61264#M10244 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe you could use some expressions like</P><P></P><P>I:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15205486560128223 jive_text_macro" jivemacro_uid="_15205486560128223"> <P>Div(Date2-Date1,7)</P> </PRE><P></P><P>or</P><P></P><P>II:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_15205486524081189 jive_text_macro" jivemacro_uid="_15205486524081189"> <P>(WeekStart(Date2)-WeekStart(Date1))/7</P> </PRE><P></P><P><IMG alt="QlikCommunity_Thread_293849_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/195780_QlikCommunity_Thread_293849_Pic1.JPG" style="height: 292px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 08 Mar 2018 22:39:06 GMT https://community.qlik.com/t5/QlikView/Week-function-not-working-when-year-changes/m-p/61264#M10244 MarcoWedel 2018-03-08T22:39:06Z