topic Help with a calculation inside a straight table in QlikView

Help with a calculation inside a straight table

Chellappan-Pillai — Sat, 16 Nov 2024 04:11:43 GMT

Hi,

I need help with a Calculation in QlikView.

I am trying to follow the Sparklines example in the Data Visualization sample.

I want the calculation to be first sum() by the d_req_date field and then the MIN(),MAX()& AVG() calculation be evaluated.

While calculating the MIN,MAX & AVG my calculation is not including the d_req_datecolumn, I don't know how to include the d_req_date aggregation in the calculation.

In Python Pandas what I am trying to get looks like below. May be this helps to better explain my situation.

I am attaching my sample, Can someone help me with the calculation?

Re: Help with a calculation inside a straight table

Anil_Babu_Samineni — Wed, 13 Mar 2019 00:56:28 GMT

Perhaps this?

Avg({<d_req_date = {"$(=Max(d_req_date))","$(=Min(d_req_date))"}>} Aggr(RangeSum(num_requests, Sum_resp_time)

, svc, req_date))

Re: Help with a calculation inside a straight table

crusader_ — Wed, 13 Mar 2019 01:08:44 GMT

Hi,

Check attached example.

hope this helps.

//Andrei