topic Re: Calculation On Load in QlikView

Calculation On Load

shane_spencer — Mon, 20 Jun 2016 10:48:21 GMT

I've got a QVD with the following fields:

Date

Hour,

Minute,

Server,

Main_metric,

sub_Metric,

value

I need to create a new value based on the following sub_Metrics:

( kbmemused - (kbcached + kbbuffers) ) / (kbmemused + kbmemfree) * 100

Can anyone help out please?

Re: Calculation On Load

swuehl — Mon, 20 Jun 2016 11:09:32 GMT

Maybe something along these lines:

INPUT:

LOAD *, AutoNumberHash256(Server,Date,Hour,Minute) as Key;

LOAD Server,

Date,

Hour,

Minute,

Main_metric,

sub_Metric,

value

FROM

(qvd);

Aggregate:

LOAD Key,

(Sum(If(sub_Metric='kbmemused',value)) - (Sum(If(sub_Metric='kbcached',value)) + Sum(If(sub_Metric='kbbuffers',value)) ) ) / (Sum(If(sub_Metric='kbmemused',value)) + Sum(If(sub_Metric='kbmemfree',value))) * 100 as Aggregate

RESIDENT INPUT

WHERE Match(sub_Metric,'kbmemused','kbcached','kbbuffers','kbmemfree')

GROUP BY Key;

edit: seems like I missed a pair of parenthesis

Re: Calculation On Load

muthukumar77 — Mon, 20 Jun 2016 11:12:06 GMT

Hi,

Refer this app,