Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
peppe7119
Contributor
Contributor

Upload this month's data by default when open the APP

Hello,
I would like to set if it was possible when an APP is opened the display in the various sheets of the current month and not all the data present (for example 10 years of stored data), this is because when I open the APP all the results.

Obviously the upload must be dynamic, so if today is September 3rd I have to see the data from September 1st to today, if I log in tomorrow September 4th I have to see the data from September 1st to 4th and so on. However, the data must always be all selectable by the user in the various time intervals, in fact I use the DatePickeRanger extension.

I tried to use bookmarks, but the value remains fixed
{<Days = {'01/09/2021', '02/09/2021'}>}

I use Qlik Sense SaaS. Possible solutions?

Thank you all

Labels (2)
1 Solution

Accepted Solutions
peppe7119
Contributor
Contributor
Author

I try this and work for me:

 

Date = Date >= monthstart(today())

 

After this create bookmark and mark it as default.

View solution in original post

2 Replies
Digvijay_Singh

I have created bookmark using the month year field and configured it as the default so that when the app is opened it filters data with the default bookmarrk. Here is the expression I use - 

=[Month Year]=Max({1} total [Month Year])

Steps to create bookmark - 

1. In the Month Year filter pane, in the search at the top, copy the above expression.

2. Press enter, don't make selection, it should show the latest month when copied the above expression.

3. Create bookmark and mark it as default.

 

Thanks,

 

peppe7119
Contributor
Contributor
Author

I try this and work for me:

 

Date = Date >= monthstart(today())

 

After this create bookmark and mark it as default.