topic Re: Expression in QlikView https://community.qlik.com/t5/QlikView/Expression/m-p/1425279#M817674 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Dual(Year(Today()<SPAN style="color: #ff0000;">-7</SPAN>) &amp; '/' &amp; Week(Today()<SPAN style="color: #ff0000;">-7</SPAN>), WeekStart(Today()<SPAN style="color: #ff0000;">, -1</SPAN>)) AS Fiscal_Year_LastWeek</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN></P></BODY></HTML> Fri, 01 Sep 2017 14:13:01 GMT sunny_talwar 2017-09-01T14:13:01Z Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1425277#M817672 <HTML><HEAD></HEAD><BODY><P>Calendar</P><P></P><P>Below is my calendar expression.. </P><P>I am writing a query and</P><P></P><P>Dual(Year(Today()) &amp; '/' &amp; Week(Today()), WeekStart(Today())) AS Fiscal_Year_LastWeek&nbsp; </P><P></P><P>from my calendar.qvd which gives me the result 2017/35</P><P></P><P>I want to show the previous week. How can I alter this. I've added -1 everywhere in the above expression.</P><P></P><P>I want to show the previous week 2017/34</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1425277#M817672 bobbydave 2020-11-25T16:16:04Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1425278#M817673 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P>Dual(Year(Today()) &amp; '/' &amp; Week(Today())<STRONG>-1</STRONG>, WeekStart(Today())) AS Fiscal_Year_LastWeek </P></BODY></HTML> Fri, 01 Sep 2017 14:06:16 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1425278#M817673 Anil_Babu_Samineni 2017-09-01T14:06:16Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1425279#M817674 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Dual(Year(Today()<SPAN style="color: #ff0000;">-7</SPAN>) &amp; '/' &amp; Week(Today()<SPAN style="color: #ff0000;">-7</SPAN>), WeekStart(Today()<SPAN style="color: #ff0000;">, -1</SPAN>)) AS Fiscal_Year_LastWeek</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> </SPAN></P></BODY></HTML> Fri, 01 Sep 2017 14:13:01 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1425279#M817674 sunny_talwar 2017-09-01T14:13:01Z Re: Expression https://community.qlik.com/t5/QlikView/Expression/m-p/1425280#M817675 <HTML><HEAD></HEAD><BODY><P>Or this</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Dual(Year(Today()<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">-7</SPAN>) &amp; '/' &amp; Week(Today()<SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #ff0000;">-7</SPAN>), WeekStart(Today()</STRONG><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #ff0000;">-7</SPAN><SPAN style="color: #3d3d3d;">)) AS Fiscal_Year_LastWeek</SPAN></STRONG></P></BODY></HTML> Fri, 01 Sep 2017 14:21:20 GMT https://community.qlik.com/t5/QlikView/Expression/m-p/1425280#M817675 sunny_talwar 2017-09-01T14:21:20Z