Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

Create bookmark with dynamic previous month

Hi experts

I have a variable which defines the previous month of a selected month: =Date(addmonths(max([Timestamp.autoCalendar.YearMonth]), -1), 'YYYY-MMM')

I tried to define a filter pane with this logic: =[Timestamp.autoCalendar.YearMonth]=$(vPreviousMonth)

But I am getting this syntax error:

TomBond77_0-1717502602116.png

Later on I would like to use the selected value as default bookmark.

Any ideas how to fix the syntax error?

Thanks, Tom

2 Replies
marcus_sommer

You may try: 

[Timestamp.autoCalendar.YearMonth]='$(vPreviousMonth)'

TauseefKhan
Creator III
Creator III

check with this:

= {< [Timestamp.autoCalendar.YearMonth] = {"$(vPreviousMonth)"} >}