How to create default bookmark with a variable in Qlik Sense

[vish123]

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

[justISO]

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.

[vish123]

Hi JustISO,

I have tried but its not working.

[chr_pro]

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

[justISO]

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.

[durgesh22]

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.

[chr_pro]

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