topic Re: How to create default bookmark with a variable in Qlik Sense in App Development

How to create default bookmark with a variable in Qlik Sense

vish123 — Mon, 25 Apr 2022 10:30:57 GMT

Hi Team,

I have created a variable called vMaxDate stored max date in it. I would like to apply a default bookmark with this variable. Can you please suggest.

Variable contains "Mar-2022".. Please suggest

Re: How to create default bookmark with a variable in Qlik Sense

justISO — Mon, 25 Apr 2022 12:29:30 GMT

Hi, try to write on your DATE filter something like this:

{<DATE={"=date(DATE)=date(vMaxDate)"}>}

where DATE is your date field/dimension. And set it to default bookmark if you see that this formula is providing correct result.

Re: How to create default bookmark with a variable in Qlik Sense

vish123 — Mon, 25 Apr 2022 16:33:51 GMT

Hi JustISO,

I have tried but its not working.

Re: How to create default bookmark with a variable in Qlik Sense

chr_pro — Tue, 26 Apr 2022 07:14:00 GMT

Hi i really need this too, would appreciate if somebody could help us

Re: How to create default bookmark with a variable in Qlik Sense

justISO — Tue, 26 Apr 2022 07:29:47 GMT

Can you provide a sample how your variable and your DATE field you apply this variable on looks like? It is hart to tell what can be wrong here, but first suggestion would be to be sure that both, variable and date field formats are the same.

Re: How to create default bookmark with a variable in Qlik Sense

durgesh22 — Tue, 26 Apr 2022 07:33:09 GMT

Enter this expression in filter created on Date field "=Num(Date)=Num(Max(ALL Date))" and "PRESS ENTER".

then create a bookmark ,set if default.

If you want to use variable

-->mxdt=Num(Max(ALL Date))

Expression is "=Num(Date)='$(mxdt)'" follow same setp as above.

Note: You can remove filter object from your dashboard if you don't want.

Re: How to create default bookmark with a variable in Qlik Sense

chr_pro — Tue, 26 Apr 2022 07:41:28 GMT

Hope its okay if i reply as well

I'm using a Button to apply the current date selection to my variable
vDateBM

=concat(distinct L_DATE,',')

and then tried to use this formula on a Date Filter Field

{<L_DATE={"=date(L_DATE)=date(vDateBM)"}>}

Probably it is the format of my variable thats not working, but i can't figure it out