https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531217#M747791 <P>Hi,</P><P>I'm trying to build a KPI. And bar chart for last 8 weeks</P><P>KPI should show me current week and previous week</P><P>Bar chart should show current week + 7 previous weeks</P><P>Everything was working fine until last day of dec falls under week 1 of 2019 that would make week 53 and week 1 together.</P><P>My expression doesn't work any more</P><P>I used max of week in set, max of date, etc etc but nothing seem to work...</P><P>Anyone know how to get 12/31 to 01/06 data with an expression?</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a></P> Sat, 16 Nov 2024 21:35:34 GMT MK9885 2024-11-16T21:35:34Z https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531217#M747791 <P>Hi,</P><P>I'm trying to build a KPI. And bar chart for last 8 weeks</P><P>KPI should show me current week and previous week</P><P>Bar chart should show current week + 7 previous weeks</P><P>Everything was working fine until last day of dec falls under week 1 of 2019 that would make week 53 and week 1 together.</P><P>My expression doesn't work any more</P><P>I used max of week in set, max of date, etc etc but nothing seem to work...</P><P>Anyone know how to get 12/31 to 01/06 data with an expression?</P><P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/46628">@sunny_talwar</a></P> Sat, 16 Nov 2024 21:35:34 GMT https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531217#M747791 MK9885 2024-11-16T21:35:34Z https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531242#M747792 Got it fixed.<BR />thanks for any help.<BR />If you still like to share your solution please do so.<BR /> Wed, 16 Jan 2019 19:22:31 GMT https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531242#M747792 MK9885 2019-01-16T19:22:31Z https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531245#M747793 have a look at weekend function!<BR />e.g.<BR />=weekend('31.12.2018')<BR /><BR />the formula should show 06.01.2019 as result! Wed, 16 Jan 2019 19:27:42 GMT https://community.qlik.com/t5/QlikView/Previous-week-amp-current-week/m-p/1531245#M747793 Frank_Hartmann 2019-01-16T19:27:42Z