topic Converting ISO Week to US Week Start and end in Year in QlikView https://community.qlik.com/t5/QlikView/Converting-ISO-Week-to-US-Week-Start-and-end-in-Year/m-p/284724#M1182971 <HTML><HEAD></HEAD><BODY><P>I found this formula in another post:</P><P>1+ceil((payrolldate-floor(weekend(yearstart(payrolldate),0)))/7)</P><P></P><P>For some reason I am still getting data in week 53 for 2011 when nothing is selected. When I select week 53 this data disappears. </P><P></P><P>Anyone have any ideas why?</P></BODY></HTML> Mon, 31 Oct 2011 14:39:52 GMT 2011-10-31T14:39:52Z Converting ISO Week to US Week Start and end in Year https://community.qlik.com/t5/QlikView/Converting-ISO-Week-to-US-Week-Start-and-end-in-Year/m-p/284724#M1182971 <HTML><HEAD></HEAD><BODY><P>I found this formula in another post:</P><P>1+ceil((payrolldate-floor(weekend(yearstart(payrolldate),0)))/7)</P><P></P><P>For some reason I am still getting data in week 53 for 2011 when nothing is selected. When I select week 53 this data disappears. </P><P></P><P>Anyone have any ideas why?</P></BODY></HTML> Mon, 31 Oct 2011 14:39:52 GMT https://community.qlik.com/t5/QlikView/Converting-ISO-Week-to-US-Week-Start-and-end-in-Year/m-p/284724#M1182971 2011-10-31T14:39:52Z