topic Re: Response time in QlikView

Response time

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Response time

MK_QSL — Mon, 04 Jul 2016 07:47:54 GMT

What is AR_SEC format?

What is SSEC format?

In what format you want the Response Time?

Re: Response time

Anonymous — Mon, 04 Jul 2016 08:02:40 GMT

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

Re: Response time

bhavvibudagam — Mon, 04 Jul 2016 13:34:44 GMT

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

Re: Response time

Anonymous — Mon, 04 Jul 2016 14:17:55 GMT

(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 .

Re: Response time

Peter_Cammaert — Mon, 04 Jul 2016 14:38:44 GMT

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

Re: Response time

bhavvibudagam — Sat, 09 Jul 2016 06:26:52 GMT

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.

Re: Response time

MarcoWedel — Sat, 09 Jul 2016 23:29:53 GMT

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;

Re: Response time

bhavvibudagam — Sun, 10 Jul 2016 15:55:01 GMT

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,

Re: Response time

MarcoWedel — Wed, 13 Jul 2016 23:02:26 GMT

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