topic Multiple week selection on opening a QlikView report in QlikView https://community.qlik.com/t5/QlikView/Multiple-week-selection-on-opening-a-QlikView-report/m-p/17470#M768860 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello Everyone,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am trying to set up a trigger which selects weeks until previous week (i.e., current week -1) by default when a user opens the report. Can anyone help me with the expression for this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I tried the following, but it isn't working as expected.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='("' &amp; Concat(Weeks-1, '"|"') &amp; '")'</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any help on this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Multiple week selection on opening a QlikView report https://community.qlik.com/t5/QlikView/Multiple-week-selection-on-opening-a-QlikView-report/m-p/17470#M768860 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello Everyone,</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I am trying to set up a trigger which selects weeks until previous week (i.e., current week -1) by default when a user opens the report. Can anyone help me with the expression for this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I tried the following, but it isn't working as expected.</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">='("' &amp; Concat(Weeks-1, '"|"') &amp; '")'</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Any help on this?</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thank you.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Multiple-week-selection-on-opening-a-QlikView-report/m-p/17470#M768860 Anonymous 2020-11-25T16:16:04Z Re: Multiple week selection on opening a QlikView report https://community.qlik.com/t5/QlikView/Multiple-week-selection-on-opening-a-QlikView-report/m-p/17471#M768861 <HTML><HEAD></HEAD><BODY><P>Hi Khrisna, can you try?</P><P>='&lt;=' &amp; (Week(Today())-1)</P></BODY></HTML> Wed, 13 Jun 2018 16:31:54 GMT https://community.qlik.com/t5/QlikView/Multiple-week-selection-on-opening-a-QlikView-report/m-p/17471#M768861 rubenmarin 2018-06-13T16:31:54Z