create dynamic bookmark for current and previous year

[hopkinsc]

Hi all,

i am trying to create a bookmark to select the current and previous fiscal years to be used in NPrinting. the bookmark needs to be dynamic though and i am struggling to get it working.

i have a field called 'FisYearNo' which has values as follows..

2016

2015

2014

2013

etc

these also relate to a field that is used in a dashboard called FiscalYearLabel which has values as follows..

2015/2016

2014/2015

2013/2014

2012/2013

etc

i am trying to just make a dynamic selection on FisYearNo by using the following syntax in a list box for FisYearNo

=>=max(FisYearNo)-1

I am guessing with the above syntax i should get 2015 and 2016 but i am getting all years as 'white'.

Does anyone know what i am doing wrong please or suggest another approach.

I have attached a sample.

[Daniel_Jenkins]

Hi Chris,

I have attached a sample project that uses NPrinting Dynamic Filters based on fields rather than QlikView bookmarks that might work for you.

Please extract to folder C:\Temp\CH to preserve the paths used or you will need to change the paths in the NSQ.

HTH - Daniel.