topic Re: Qlikview DayStart Function in QlikView

Qlikview DayStart Function

obriened83 — Mon, 26 Jan 2026 18:19:17 GMT

Has anyone noticed that when you use the DayStart Function in the Edit Screen that it maxes out all CPU (No matther how many) when the function is been executed? This can cause Qlikview server load issues as well. I was wondering if this was a Qlikview memory issue?

Thanks very much.

Kind Regards

Eamonn

Re: Qlikview DayStart Function

swuehl — Wed, 30 Jan 2013 13:53:52 GMT

Using Daystart() function in the script causes high CPU usage? No, I haven't noticed that before.

[And I believe daystart() is a pretty simple operation and shouldn't cost much at all.]

Besides, how do you tell that it is exactely this function that causes high CPU usage?

Could you post a small sample script that demonstrate this issue?

Re: Qlikview DayStart Function

obriened83 — Wed, 30 Jan 2013 16:56:07 GMT

Hi Swuehi

Sorry about being late in getting back to you. Please find below the query and a screenshot of the server cpu usage. The data is a cust ID ([Customer_Raw.cust_id]) and a Date timestamp (Customer_Raw.cr_date). If you have any quereis I would be more than happy to help. Thanks very much.

Kind Regards

Eamnonn

Code

Customer:
LOAD [Customer_Raw.cust_id] AS %cust_id
, [Customer_Raw.cr_date] AS [Registation DateTime]
, Date(DayStart([Customer_Raw.cr_date])) AS [Registration Date]

FROM

(qvd);