Response time

[bhavvibudagam]

Hi,

I have two fields like this.By this two fields i need to calculate the response time the out is like 10.68 , 15.70....

the formula given by the client is AR_SEC - SSEC.How to get the response time can we change the format of AR_SEC.Please help me to do.

Thanks

[MK_QSL]

What is AR_SEC format?

What is SSEC format?

In what format you want the Response Time?

[Anonymous]

Hi

If both are seconds  and you want difference(response time) in time in MINUTES

please try this in LOAD statement !?

(AR_SEC-SSEC)/60 AS response_TIME

[bhavvibudagam]

I am working on UI Can i use this expression like this

=Count({<Year={$(=Max(Year)-1)},AGENCY={'O'}>}(AR_SEC- SSEC))/60

but getting like 129.98, 337.02 ....

is their any other solution

[Anonymous]

Hi

(AR_SEC-SSEC)/60 AS response_TIME       for converting seconds in to minutes

(AR_SEC-SSEC)/(60*60) AS response_TIME         for converting seconds in to hours

(AR_SEC-SSEC)/(60*60*24) AS response_TIME         for converting seconds in to days

1)But, i can not understand what is your requirement ?  for which time format are you looking for ?

2)please post some sample qvw Or datafile .

[Peter_Cammaert]

How about this? For example, put this expression in a text box to see whether you get any decent results.

=Avg(AR_SEC - SSEC)/60

Otherwise, please do as Manish suggested and exaplin what these values represent. Because while we assume that they are a time value in number of seconds, they may also be in milliseconds...

Peter

[bhavvibudagam]

Hi,

I have attached the sample qvw file.Please find the below.

I have Two fields AR_SEC,S_SEC.need to calculate he median response time for these two fields.

The output like for priority1  -->6.08 minutes.Please help me to calculate the median response time.

[MarcoWedel]

Hi,

your AR_SEC and SSEC timestamps seem to be Unix/Epoch timestamps.

So one solution might be:

table1:
LOAD *,
    Interval(AR_SEC - SSEC) as [response time];
LOAD CDTS_Date,
    Timestamp(25569+AR_SEC/86400) as AR_SEC,
    Timestamp(25569+SSEC/86400) as SSEC,
    PRIORITY
FROM  (txt, utf8, embedded labels, delimiter is '\t', msq, no eof);

tabCalendar: 
LOAD *, 
    Day(Date) as Day, 
    WeekDay(Date) as WeekDay, 
    Week(Date) as Week, 
    WeekName(Date) as WeekName, 
    Month(Date) as Month, 
    MonthName(Date) as MonthName, 
    Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 
    QuarterName(Date) as QuarterName, 
    Year(Date) as Year, 
    WeekYear(Date) as WeekYear;   
LOAD Date(MinDate+IterNo()-1) as Date 
While MinDate+IterNo()-1 <= MaxDate; 
LOAD Min(CDTS_Date) as MinDate, 
    Max(CDTS_Date) as MaxDate 
Resident table1;

see also:

Re: Convert Timestamp

UNIX DATE to Qlikview DATE

convert epoch time to EST with consideration of DST

hope this helps

regards

Marco

[bhavvibudagam]

Hi Marco,

Thank you so much for your response.

Can you help me how to calculate MTM Current,MTM Previous,YTD Current, YTD previous Response Times.

Thanks,

[MarcoWedel · Accepted solution]

glad it helped.

Please close your thread if your initial question is answered and open a new one for this new question.

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco