topic Re: Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file? in QlikView

Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi users,

I have used some variables in the front end of the QlikView Application layer.

Hence one of the text boxes on the front end app showed '27th March 2018' after the reload last night as I had used 'floor(today())' as variable definition.

Today is 28th March 2018 and when I open the App file, will the text box automatically show '28th or 27th March 2018' without me reloading the file again??

Re: Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

sunny_talwar — Wed, 28 Mar 2018 14:35:04 GMT

I think Today() will show 27th March 2018, but Today(1) will show 28th March 2018

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/today.htm

Re: Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

sunny_talwar — Wed, 28 Mar 2018 14:39:42 GMT

My bad, Today() and Today(1) will show 28th March 2018... but Today(0) will show 27th March 2018

Re: Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

olivierrobin — Wed, 28 Mar 2018 15:12:21 GMT

hello

extracted from qv documentation

The time functions e.g. Now() and Today() will be evaluated whenever a recalculation is required.

Especially the Now() function can become quite costly since it causes a recalculation of the application

Re: Does user defined variables(date function) on the front end automatically refresh with today's date every time I open the application file?

Anonymous — Wed, 28 Mar 2018 15:24:14 GMT

Hi,

Try the below one.

Date(Now(),'DD/MMM/YYYY')

Thanks,

Venkata Sreekanth