topic Re: create dynamic bookmark for current and previous year in QlikView

create dynamic bookmark for current and previous year

hopkinsc — Tue, 18 Aug 2015 14:31:15 GMT

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.

Re: create dynamic bookmark for current and previous year

ecolomer — Tue, 18 Aug 2015 14:52:23 GMT

Is this you need?

Re: create dynamic bookmark for current and previous year

hopkinsc — Tue, 18 Aug 2015 14:56:18 GMT

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.

Re: create dynamic bookmark for current and previous year

ecolomer — Tue, 18 Aug 2015 15:03:52 GMT

Yes, now?

Re: create dynamic bookmark for current and previous year

ecolomer — Tue, 18 Aug 2015 15:04:20 GMT

Now you have a Bookmark = "MyBookMark"

Is ok?

Re: create dynamic bookmark for current and previous year

hopkinsc — Tue, 18 Aug 2015 15:06:58 GMT

That bookmark does nothing....

Re: create dynamic bookmark for current and previous year

ecolomer — Tue, 18 Aug 2015 15:09:23 GMT

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

Re: create dynamic bookmark for current and previous year

hopkinsc — Tue, 18 Aug 2015 15:14:08 GMT

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.

Re: create dynamic bookmark for current and previous year

ecolomer — Tue, 18 Aug 2015 15:16:09 GMT

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 ....

Re: create dynamic bookmark for current and previous year

henrybrinkmann — Tue, 18 Aug 2015 15:22:10 GMT

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;

Henry

Re: create dynamic bookmark for current and previous year

Daniel_Jenkins — Fri, 21 Aug 2015 02:38:54 GMT

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.