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.

[ecolomer]

Is this you need?

[hopkinsc]

Hi, thanks, thats the result i need but i need it in a bookmark. i cant bookmark that as it will select those values no matter what the current year is.

the bookmark is needed for an NPrinting filter, so it needs to be dynamic.

[ecolomer]

Yes, now?

[ecolomer]

Now you have a Bookmark = "MyBookMark"

Is ok?

[hopkinsc]

Hi

That bookmark does nothing....

[ecolomer]

When you push buton, the value are selected and updated the bookmark

[hopkinsc]

Hi, i dont think you understand my requirement.

i need a bookmark to dynamically select the current fiscal year and the previous fiscal year.

the bookmark is to be used by NPrinting, not to be used by a qlikview user so no 'Button' can be clicked in QlikView first.

[ecolomer]

In my example, you have an buton to activate the selection and update the bookmark.

Now you can activate a trigger when open the QV file execute the buton and ....

[henrybrinkmann]

Hi!

You can try to create a 3rd field with age(). Then bookmark '0 Year' and '1 Year'. Next year the value FisYearNo changes, but your bookmark is still correct.

Date:

Load * inline [

FisYearNo, FisYearLabel

2016, 2015/2016

2015, 2014/2015

2014, 2013/2014

2013, 2012/2013

]

;

Date2:

LOAD *,

  age(Today(), MakeDate(FisYearNo)) & ' Year' as ForBookMark

Resident Date;

drop Table Date;

BR

Henry