https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1836049#M33372 <P>No worries <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/55524">@hitha1512</a></P> Tue, 14 Sep 2021 14:14:01 GMT Frank_S 2021-09-14T14:14:01Z https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835782#M33361 <P>Hi Team,</P><P>I need to generate report for previous month data using NPrinting. Tried applying various filter to get previous months data, but failed.&nbsp;</P><P>Since i am new to Nprinting, any help would be appreciated.</P> Mon, 13 Sep 2021 20:43:05 GMT https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835782#M33361 hitha1512 2021-09-13T20:43:05Z https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835786#M33362 <P>You need a <STRONG>dimension </STRONG>in your data model for <STRONG>month</STRONG>.</P><P>For example, dimension: '<STRONG>Month</STRONG>'</P> <UL> <LI>Create and NPrinting filter using '<STRONG>Month</STRONG>' dimension</LI> <LI>Use the following formula <STRONG>Month(now()) - 1</STRONG></LI> <LI>(dimensions usage is 'case sensitive' so spell your dimension correctly.</LI> <LI>The filter type needs to be set to 'evaluate'</LI> <LI>Save the filter</LI> <LI>Add the filter to your report, or your task but not to both.</LI> </UL> <P>Use the following link which explains more about filters:</P> <UL> <LI><A href="https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-8" target="_blank">https://help.qlik.com/en-US/nprinting/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-8</A></LI> </UL> <P>Kind regards...</P> Mon, 13 Sep 2021 21:20:47 GMT https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835786#M33362 Frank_S 2021-09-13T21:20:47Z https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835840#M33364 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/48712">@Frank_S</a>&nbsp;&nbsp;thank you <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> that worked.&nbsp;</P> Tue, 14 Sep 2021 03:57:06 GMT https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1835840#M33364 hitha1512 2021-09-14T03:57:06Z https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1836049#M33372 <P>No worries <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/55524">@hitha1512</a></P> Tue, 14 Sep 2021 14:14:01 GMT https://community.qlik.com/t5/Qlik-NPrinting/Applying-filter-in-Nprinting/m-p/1836049#M33372 Frank_S 2021-09-14T14:14:01Z