topic Re: Calendar Function in QlikView

Calendar Function

Wed, 25 Nov 2020 16:16:04 GMT

Hi Team,

I have 2 questions regarding the calendar .

1st Questions : I have a requirement where in the Text object should pop the current date referring to the system whenever its is reloaded . I have used a text object with the text filled in [ = ' DATE: ' & today() ], but it is not refreshing continuously.

2nd Question :

We have a requirement where we want the calendar to pick the current date from all the values of the column which its referring to . and display the values of the selected date .

Can we have actions to the calendar.

Re: Calendar Function

sunny_talwar — Wed, 15 Jun 2016 16:40:54 GMT

Continuously? You are looking to get the time? May be Now()

or if you need the last reload date -> Today(0)

or for last reload time -? ReloadTime()

Re: Calendar Function

swuehl — Wed, 15 Jun 2016 16:50:25 GMT

Yes, have a look at the timer mode argument values you can use with the today() function, chose the one which serves your need.

today ‒ QlikView

But maybe you are experiencing a refresh issue as well, which client are you using?

Have a look at

AutoRefresh Document Extension

Re: Calendar Function

Wed, 15 Jun 2016 17:15:06 GMT

Hi Sunny ,

I need the Date in the Text object needs to get refreshed when ever i reload the Sheet. that is what exactly im looking for , can u please help me on that .

And also can u please let me know is there a way i can automate the sheet to reload automatically once a day , can u please help me here .

Re: Calendar Function

Wed, 15 Jun 2016 17:16:08 GMT

Hi Swuehl ,

Thanks for the reply ,

can u please help me here in the second question .

2nd Question :

We have a requirement where we want the calendar to pick the current date from all the values of the column which its referring to . and display the values of the selected date .

Can we have actions to the calendar.

Re: Calendar Function

Wed, 15 Jun 2016 17:20:57 GMT

2nd Question :

We have a requirement where we want the calendar to pick the current date from all the values of the column which its referring to . and display the values of the selected date .

Can we have actions to the calendar.

Re: Calendar Function

Thu, 16 Jun 2016 16:31:09 GMT

Hi Sunny Appreciate your help on the Automatic Reloads

We have a requirement where we want the calendar to pick the current date from all the values of the column which its referring to . and display the values of the selected date .

Can we have actions to the calendar ?

Re: Calendar Function

Thu, 16 Jun 2016 16:32:16 GMT

Hi Swuehl,

Appreciate your help on referring links .

We have a requirement where we want the calendar to pick the current date from all the values of the column which its referring to . and display the values of the selected date .

Can we have actions to the calendar ?