topic Re: TODAT FUNCTION in QlikView

TODAT FUNCTION

Fri, 08 Mar 2013 12:55:08 GMT

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?

Re: TODAT FUNCTION

kaushiknsolanki — Fri, 08 Mar 2013 12:57:02 GMT

What expression you are using?

Regards,

Kaushik Solanki

Re: TODAT FUNCTION

Fri, 08 Mar 2013 12:57:53 GMT

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

Re: TODAT FUNCTION

kaushiknsolanki — Fri, 08 Mar 2013 13:02:14 GMT

Expression seems to be ok.

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

Regards,

Kaushik Solanki

Re: TODAT FUNCTION

Fri, 08 Mar 2013 13:08:17 GMT

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

kaushiknsolanki — Fri, 08 Mar 2013 13:10:11 GMT

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

Re: TODAT FUNCTION

Fri, 08 Mar 2013 13:12:02 GMT

I am using the personal edition.

Re: TODAT FUNCTION

Anonymous — Fri, 08 Mar 2013 13:34:48 GMT

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

Re: TODAT FUNCTION

Fri, 08 Mar 2013 13:52:34 GMT

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