topic MTD Logic Problem in QlikView https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129510#M758796 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>This expression is working fine for MTD Logic</P><P>Sum({&lt;Date_Comm=,FY_Date_Num={"&gt;=$(=Num(MonthStart(Max(FY_Date_Num))))&lt;=$(=Max(FY_Date_Num))"}&gt;} Bud_Sales)</P><P></P><P>Example: Date_Comm&nbsp; is dimention</P><P>On selecting Date_Comm feild the above expression gives the correct output.</P><P>Daily= 0.2</P><P>MTD= 0.41</P><P></P><P>On contrary, applying = Date_Comm as selection the output is</P><P>Daily= 0.2</P><P>MTD= 0.2</P><P></P><P>I suppose bypass is not working when we add = sign to selected dimention ( eg : = Date_Comm ) filter.</P><P>We need to add&nbsp; = sign with the calender extension.</P><P></P><P>Kindly provide solution on the above problem</P><P></P><P>Please find below attachment</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT sameeramalik 2020-11-25T16:16:04Z MTD Logic Problem https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129510#M758796 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>This expression is working fine for MTD Logic</P><P>Sum({&lt;Date_Comm=,FY_Date_Num={"&gt;=$(=Num(MonthStart(Max(FY_Date_Num))))&lt;=$(=Max(FY_Date_Num))"}&gt;} Bud_Sales)</P><P></P><P>Example: Date_Comm&nbsp; is dimention</P><P>On selecting Date_Comm feild the above expression gives the correct output.</P><P>Daily= 0.2</P><P>MTD= 0.41</P><P></P><P>On contrary, applying = Date_Comm as selection the output is</P><P>Daily= 0.2</P><P>MTD= 0.2</P><P></P><P>I suppose bypass is not working when we add = sign to selected dimention ( eg : = Date_Comm ) filter.</P><P>We need to add&nbsp; = sign with the calender extension.</P><P></P><P>Kindly provide solution on the above problem</P><P></P><P>Please find below attachment</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129510#M758796 sameeramalik 2020-11-25T16:16:04Z Re: MTD Logic Problem https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129511#M758797 <HTML><HEAD></HEAD><BODY><P>pls help</P><P><A href="https://community.qlik.com/qlik-users/120618">mrkachhiaimp</A>‌</P><P><SPAN class="j-simple-name font-color-normal"><A href="https://community.qlik.com/qlik-users/2006">jimhalpert</A>‌</SPAN></P><P><SPAN class="j-simple-name font-color-normal"><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌<BR /></SPAN></P></BODY></HTML> Tue, 28 Aug 2018 13:40:57 GMT https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129511#M758797 sameeramalik 2018-08-28T13:40:57Z Re: MTD Logic Problem https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129512#M758798 <HTML><HEAD></HEAD><BODY><P>Please Reply</P><P>I am new to qlik</P></BODY></HTML> Wed, 29 Aug 2018 07:52:50 GMT https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129512#M758798 sameeramalik 2018-08-29T07:52:50Z Re: MTD Logic Problem https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129513#M758799 <HTML><HEAD></HEAD><BODY><P>This is weird behavior, Can you attach your QVF file</P></BODY></HTML> Thu, 30 Aug 2018 13:04:44 GMT https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129513#M758799 Anil_Babu_Samineni 2018-08-30T13:04:44Z Re: MTD Logic Problem https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129514#M758800 <HTML><HEAD></HEAD><BODY><P>Can you share a sample file?</P></BODY></HTML> Thu, 30 Aug 2018 13:08:39 GMT https://community.qlik.com/t5/QlikView/MTD-Logic-Problem/m-p/129514#M758800 neelamsaroha157 2018-08-30T13:08:39Z