topic Re: Actions on opening document in QlikView

Actions on opening document

Mon, 03 Apr 2017 13:13:17 GMT

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

Re: Actions on opening document

aarkay29 — Mon, 03 Apr 2017 13:20:52 GMT

May be try this

=Year(today())

=Month(today())

=Day(today())

Re: Actions on opening document

Mon, 03 Apr 2017 14:14:33 GMT

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.

Re: Actions on opening document

Anonymous — Mon, 03 Apr 2017 14:16:56 GMT

Is it possible to share the .qvw??

Re: Actions on opening document

Mon, 03 Apr 2017 14:18:17 GMT

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

Re: Actions on opening document

Anonymous — Mon, 03 Apr 2017 14:42:11 GMT

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.

Re: Actions on opening document

israelcsouza — Mon, 03 Apr 2017 17:44:17 GMT

Hi,

= Year(Today())

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

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

Re: Actions on opening document

Anonymous — Mon, 03 Apr 2017 17:48:25 GMT

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