topic Re: Need Help?? in QlikView

Need Help??

paulwalker — Mon, 18 May 2015 12:21:42 GMT

Hi Community,

i have one table like this..

START DT/TIME END DT/TIME Reload Time RowsLoaded Avg Per Min

05/14/2015 00:15:35 05/14/2015 00:16:00 00.01.25 80

05/14/2015 08:15:35 05/14/2015 08:16:00 00:01:12 70

I have calculated Reload time between startdate and enddate.

Here, how to calculate Rows Loaded per Min?

PrashantSangle — Mon, 18 May 2015 12:32:42 GMT

Hi,

Convert your reload Time into Min only then divide it by RowsLoaded will give avg per Min.

Regards,

sunny_talwar — Mon, 18 May 2015 12:36:04 GMT

Try this:

Table:

LOAD *,

RowsLoaded*60/Num(Num#(Interval(ReloadTime, 'ss'), '##')) as [Avg Per Min];

LOAD * INLINE [

ReloadTime, RowsLoaded

00:01:25, 80

00:01:12, 70

];

Output:

sunny_talwar — Mon, 18 May 2015 12:36:59 GMT

PFA a sample application for your reference:

Best,

Sunny