I have a problem with calculated a duration time ( hh mm ss ) for every events occours for each diplay name name : I have one field that contains a date (from data time) and I would like to have a duration time between the change from a result of events and another for each diplay name.
How I can filter in field explanation the part about memory and CPU, for example, ho have the percentage of used and avaible ?
In attach the access file and a qlik file test .
Can you help me please.. it's very urgent for me calculated this value today.
my problem is calculated the duration time from an event to an other referred a display name server. I hav only a start time period but I don't have a totime period. So the only mode to calculated the duration time is the difference from the start time of an event to a start time of another event referred to the same display name server.
The source file is an mdb file , that you will find in my post ..
Can you help me please .. I must compile my qlik file today !
reload your table "Events", sorted by CheckID and Date (descending), and use functions previous() and peek() to get the Date/Time from the previous record (sorted descending, it would be your next event). Decide how you want to calculate the duration for the last event. In the following example, I assign 0 to the very last event.
Try something like this:
Events1: load *, if( previous(CheckID) <> CheckID, 0, peek(FromDate) - FromDate) as EventDuration resident Events ORDER BY CheckID, FromDate DESC ; drop table Events;
I' don't receive any updates about my qyestion ...... I have aproblem with calculated the difference about the first value to compared with my first TimeString value... How I can modify the script as well as !!????