Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
hariharan1410
New Contributor

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

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??

4 Replies

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

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/DateAndTimeFun...

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

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

olivierrobin
Valued Contributor III

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

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

venkatasreekant
Valued Contributor

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

Hi,


Try the below one.


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


Thanks,

Venkata Sreekanth