topic Week(now()) cause for straight table refresh? in QlikView

Week(now()) cause for straight table refresh?

Thu, 22 Sep 2011 13:50:42 GMT

Hello,

I have a straight table which shows the number of hours a person had to work according tot a certain norm. To give sensible results I used Week(now()) to display the current amount of hours.

But now the straight table is constantly refreshing and takes a lot of resources (like CPU and memory). Can the use of Week(now()) be the cause?

Is there another solution to sum up the hours and show the sum for the current week?

Thanks!

Week(now()) cause for straight table refresh?

swuehl — Thu, 22 Sep 2011 14:03:17 GMT

Now() is returning the time at function call. As the help states, this may result in performance problems and that is what you see.

But you could probably use Now(0) or Now(2) to prevent performance issues, please have a look at the Help for details.

Regards,

Stefan

Week(now()) cause for straight table refresh?

Thu, 22 Sep 2011 14:05:30 GMT

Hi,

If you have data only till this week, week=max(week) in set analysis will be enough. However what is the datavolume here?

Thanks,

Kiran.

Week(now()) cause for straight table refresh?

Thu, 22 Sep 2011 14:17:12 GMT

Thanks swuehl, that did the trick.

I was looking in the help but couldn't find anything.