https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660993#M10784 <P>Hi,&nbsp;</P><P>What is your variable <EM><SPAN>VCurrentMonth</SPAN></EM>?&nbsp;</P><P>Should be something like "Month(Today()) ".</P><P>Are you also sure you have a good filter on the year? Your month has to be a combinaison of the month and the year in order to only get, for instance, the december of this year and not all the decembers in your data.&nbsp;</P><P>Regards,&nbsp;</P> Fri, 27 Dec 2019 12:38:59 GMT benoitgochel 2019-12-27T12:38:59Z https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660660#M10780 <P>Sum({&lt;AmountCr={"&gt;0"},CommenceMonth={'$(VCurrentMonth)'}&gt;}AmountCr)</P> <P>&nbsp;</P> <P>I'm getting whole year data but i want only Current month Data..</P> <P>Please help here.</P> <P>&nbsp;</P> <P>&nbsp;</P> Fri, 07 Feb 2020 21:51:49 GMT https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660660#M10780 mnvrma 2020-02-07T21:51:49Z https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660662#M10781 <P>I think we just need to check the date format.<BR />Does CommenceMonth and VCurrentMonth have the same format ?</P> Thu, 26 Dec 2019 08:36:25 GMT https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660662#M10781 Taoufiq_Zarra 2019-12-26T08:36:25Z https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660993#M10784 <P>Hi,&nbsp;</P><P>What is your variable <EM><SPAN>VCurrentMonth</SPAN></EM>?&nbsp;</P><P>Should be something like "Month(Today()) ".</P><P>Are you also sure you have a good filter on the year? Your month has to be a combinaison of the month and the year in order to only get, for instance, the december of this year and not all the decembers in your data.&nbsp;</P><P>Regards,&nbsp;</P> Fri, 27 Dec 2019 12:38:59 GMT https://community.qlik.com/t5/Water-Cooler/How-to-get-current-month-data/m-p/1660993#M10784 benoitgochel 2019-12-27T12:38:59Z