Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!