Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Open app with current month selection on dates

Hi

I have have a qvd

load

invoice id

invoice date

part number

et...

FROM xyz

 

How can I set the app such then when it opens it show current month for invoice dates i.e. if i open app today it shows only october dates, if i opened it yesterday it would have shown me only september

 

thanks

2 Replies
jwjackso
Specialist III
Specialist III

Check out Dynamic default bookmark 

If your maximum [Invoice Date] is in October, the formula would be 

[Invoice Date]=MonthStart(Now())

If you have [Invoice Date] that has data after October and you have a field like MonthYear that look like Oct-2020, the formula would be like

=[MonthYear]=Month(Now())&'-'&Year(Now())

 

pgalvezt
Specialist
Specialist

Hello !

Enter to this page: https://www.youtube.com/watch?v=GGIPAs1HpUo 

There is the answer you are looking for, it works perfectly for me and every time a model is reloaded it shows me the updated date.

Good Luck!