topic Using wild character in Nprinting field value in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Using-wild-character-in-Nprinting-field-value/m-p/1002151#M7495 <HTML><HEAD></HEAD><BODY><P>We have a macro where we have a filter on date field. In macro we are assign it value as year(now()) &amp; * . Now we are tring to do the same export using Nprinting , where the wild character * is not being identified&nbsp; . How can we implement this same date selection ( &amp; * part ) in Nprinting.</P></BODY></HTML> Tue, 22 Sep 2015 13:56:56 GMT 2015-09-22T13:56:56Z Using wild character in Nprinting field value https://community.qlik.com/t5/Qlik-NPrinting/Using-wild-character-in-Nprinting-field-value/m-p/1002151#M7495 <HTML><HEAD></HEAD><BODY><P>We have a macro where we have a filter on date field. In macro we are assign it value as year(now()) &amp; * . Now we are tring to do the same export using Nprinting , where the wild character * is not being identified&nbsp; . How can we implement this same date selection ( &amp; * part ) in Nprinting.</P></BODY></HTML> Tue, 22 Sep 2015 13:56:56 GMT https://community.qlik.com/t5/Qlik-NPrinting/Using-wild-character-in-Nprinting-field-value/m-p/1002151#M7495 2015-09-22T13:56:56Z Re: Using wild character in Nprinting field value https://community.qlik.com/t5/Qlik-NPrinting/Using-wild-character-in-Nprinting-field-value/m-p/1002152#M7496 <HTML><HEAD></HEAD><BODY><P>NPrinting is unable to calculate an array of values which your formula suggests. Any formula resulting in a boolean query ( a yes/no) will not work. You must specify a specific value.</P><P></P><P>You can leverage Qlik advanced search functionality by following the tutorial below which allows the use of a special character.:</P><P></P><P><A href="http://community.vizubi.com/knowledgebase/articles/413836-how-to-use-qlikview-advanced-search-with-nprinting" title="http://community.vizubi.com/knowledgebase/articles/413836-how-to-use-qlikview-advanced-search-with-nprinting">How to Use QlikView Advanced Search with NPrinting Filters – Customer Feedback for Vizubi</A></P><P></P><P>Keep in mind that any macros run on your template will be run after the NPrinting report is generated.</P><P></P><P>You must use the following formats to build an NPrinting template using a macro: xlsm, pptx.</P><P></P><P>Hope this helps.</P></BODY></HTML> Tue, 22 Sep 2015 15:57:47 GMT https://community.qlik.com/t5/Qlik-NPrinting/Using-wild-character-in-Nprinting-field-value/m-p/1002152#M7496 Frank_S 2015-09-22T15:57:47Z