https://community.qlik.com/t5/Qlik-NPrinting/Dynamic-filter-in-Nprinting/m-p/1781150#M31167 <P>Hi,</P><P>Be sure that both, the field and the formula result, are of the same type. For example you could force the formula to return a string by adding a Text().</P><P>Remember also to select Evaluate value from the dropdown menu.</P><P>Best Regards,</P><P>Ruggero</P> Tue, 09 Feb 2021 10:34:36 GMT Ruggero_Piccoli 2021-02-09T10:34:36Z https://community.qlik.com/t5/Qlik-NPrinting/Dynamic-filter-in-Nprinting/m-p/1781146#M31165 <P>HI,</P><P>I'll try to use dynamic filter for the dimesion where the format is Yearmonthnumber like 20212.</P><P>I have selected dimension VuosiPeriodi&nbsp;</P><P>Value is: =(Year(addmonths(Now(),-1))&amp;num(month(addmonths(Now(),-1)))),</P><P>but this lead to error. If I put directly 20211 it works fine.</P><P>How I should create a dynamic filter that it is working.&nbsp;</P><P>Thanks!</P><P>Regards, Jarmo</P> Tue, 09 Feb 2021 10:19:55 GMT https://community.qlik.com/t5/Qlik-NPrinting/Dynamic-filter-in-Nprinting/m-p/1781146#M31165 JarmoKoponen 2021-02-09T10:19:55Z https://community.qlik.com/t5/Qlik-NPrinting/Dynamic-filter-in-Nprinting/m-p/1781150#M31167 <P>Hi,</P><P>Be sure that both, the field and the formula result, are of the same type. For example you could force the formula to return a string by adding a Text().</P><P>Remember also to select Evaluate value from the dropdown menu.</P><P>Best Regards,</P><P>Ruggero</P> Tue, 09 Feb 2021 10:34:36 GMT https://community.qlik.com/t5/Qlik-NPrinting/Dynamic-filter-in-Nprinting/m-p/1781150#M31167 Ruggero_Piccoli 2021-02-09T10:34:36Z