Alternative to now()

gerhardl — Wed, 16 Jan 2013 07:01:04 GMT

Hi There,

I have a bit of a challenge (then again, maybe it's easy for someone here).

On my application's welcome page, I want to add a text object that shows the number of accounts that are Open, "and counting", i.e. I want the number to increase (more or less) at the speed it does in reality.

The module is only reloaded every morning, so the data is 100% correct then. On average we open 600 accounts a day, so that is (more or less) an account every one minute (if I just count the hours in the work day).

So I can do this using the now() function, and manipulating it to a number value that increases at the above speed. Something like this:

=num(Count({$<[Account Status]={'D','N','U','A'}>}[Account No])+(right(round(num(time(now()))*1000,2),3)-300),',##0')&' Open Accounts.... and counting'

But I do not want to use the now() function because I do not want to cause performance issues.

Any idea how else I can increase the value of an expression with one,every minute or so?

Thanks,

Gerhard

Re: Alternative to now()

rustyfishbones — Fri, 07 Jul 2017 12:10:16 GMT

Did you find alternative to using NOW()

Re: Alternative to now()

Anonymous — Fri, 07 Jul 2017 12:14:19 GMT

what about now(2) ?

Then it will be calculated once when opening the document....

topic Re: Alternative to now() in QlikView

Alternative to now()

Re: Alternative to now()

Re: Alternative to now()