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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Actions on opening document

I have a few actions on opening a document. The first 3 are to select the year, month and day to current day as follows:

=Year(YearStart(today()))

=Month(MonthStart(today()))

=Day(DayStart(today()))

This used to work fine for the past months but for some reason as of April 1st, it stopped selecting the year. If  I change the order to select the month first and year second, then the month doesn't get selected. It seems the first action stopped working. Is it a known bug or is there a better way to do this date selection to automatically select today's date when the document is opened?

Thanks,

Amit

7 Replies
aarkay29
Specialist
Specialist

May be try this

=Year(today())

=Month(today())

=Day(today())

Not applicable
Author

Didn't help - the year was not selected.

I should precise that on the client it does the selection but on the access point when I open the dashboard this is where the issue occurs.

Anonymous
Not applicable
Author

Is it possible to share the .qvw??

Not applicable
Author

Unfortunately I can't it does contain sensitive company data that I am not allowed to share to the public... sorry

Anonymous
Not applicable
Author

Might not  be a perfect solution but can you delete the actions and recreate them once??  It happened to me once. I was unaware of the reason but the buttons worked normally later on.

israelcsouza
Contributor III
Contributor III

Hi,


= Year(Today())

= Month(AddMonths(Date(today()),0))

= DAY(AddMonths(Date(today()),0))

Anonymous
Not applicable
Author

did you try today(1) or today(2) ?