Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

TODAT FUNCTION

When i set an expressionto use the today() to calc network days it works great.  However when I refresh the app it will not refresh this column.  The only way this column gets freshed is when I close the app and restart it.  is there a way around this?

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: TODAT FUNCTION

It is strange...  BTW, the correct result today is 5, not 6.  In any case, I recommend some changes.  Most important, redefine "today" as the reload time rathter than actual current date:


NetWorkDays(MonthStart(ReloadTime()),floor(ReloadTime())-1)

Regards,
Michael

8 Replies

Re: TODAT FUNCTION

What expression you are using?

Regards,

Kaushik Solanki

Not applicable

Re: TODAT FUNCTION

NetWorkDays(MonthStart(Today()),(Today())-1)

Re: TODAT FUNCTION

Expression seems to be ok.

Is it possible for u to send the QVW file, with the data.

Regards,

Kaushik Solanki

Not applicable

Re: TODAT FUNCTION

How do I add the QVW file?  Also, the function works great.  lets say it yields "5" days for the field, the next day I can come in and try to refresh the file and it will still say "5" days', however if I close the app down and open it back up it will then say "6" days. 

Re: TODAT FUNCTION

It appears to be a strange behavior.

You can click on "Use Advanced Editor" above the post area, to include the attachment.

Regards,

Kaushik Solanki

Not applicable

Re: TODAT FUNCTION

I am using the personal edition.

mov
Esteemed Contributor III

Re: TODAT FUNCTION

It is strange...  BTW, the correct result today is 5, not 6.  In any case, I recommend some changes.  Most important, redefine "today" as the reload time rathter than actual current date:


NetWorkDays(MonthStart(ReloadTime()),floor(ReloadTime())-1)

Regards,
Michael

Not applicable

Re: TODAT FUNCTION

I will give this a try, thanks soooo much for your help!!