Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
fernfrancis
Contributor
Contributor

adding current date as filter to bookmark

Hi Team,

I am trying to make a dynamic filter so that when the page loads it give the data for the current month. When i try this it gives me the correct data *-05-2022  but when i try to make it dynamic by using the expression =Month(Today()) it does not fetch any data. 

If someone can help me with this to so that i can save it as a bookmark. 

Labels (1)
8 Replies
salonicdk28
Creator II
Creator II

Try this in your month filter and then on entering save it as default bookmark, it will fetch the data only for the current month whenever you open the application

=Month=Month(Today())

fernfrancis
Contributor
Contributor
Author

Well my column name is Book_Date. so changed the formula to =Book_Date = =Month(Today()). but still no luck

salonicdk28
Creator II
Creator II

You need to calculate month field first  from Book_Date like Month(Book_Date) in the script and then in the month filter, write the expression as mentioned above, hopefully it will work 

HugoRomeira_PT
Creator
Creator

Hello,

 

You can use the following statement:

= Book_Date >= monthstart(today()) and Book_Date<= monthend(today())

Hope it helps

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.
fernfrancis
Contributor
Contributor
Author

I Tried what you mentioned, but when i try to use the filter =Month(Today()) it fetches all the months does not select the current month

fernfrancis
Contributor
Contributor
Author

Dine work in my case. 

salonicdk28
Creator II
Creator II

You need to write like below expression in the filter-

=Month=Month(Today())

and if your  issue is solved please mark the answer with Accept as Solution.

Thanks,

Saloni

HugoRomeira_PT
Creator
Creator

Hi

1. You must select the field that you wish to filter and apply the expression = Book_Date >= monthstart(today()) and Book_Date<= monthend(today()), then press enter, and click on confirm selection button (green check)

HugoRomeira_PT_0-1652975668336.png

2. Then create the bookmark, give it a name and confirm

HugoRomeira_PT_1-1652975881165.png

 

3. After it's create you will see that the bookmark has the following definition

note: in my case I've applied as well another filter to the bookmark: vendor type={'External'}, you should ignore this part

HugoRomeira_PT_2-1652975981176.png

 

4. Test it, it should work

 

Hope it helps!

 

 

 

 

If the issue is solved please mark the answer with Accept as Solution.
If you want to go quickly, go alone. If you want to go far, go together.