Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Chellappan-Pillai
New Contributor

Help with a calculation inside a straight table

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.image.png

 

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

 

Labels (2)
1 Solution

Accepted Solutions
Partner
Partner

Re: Help with a calculation inside a straight table

Hi,

Check attached example.

hope this helps.

//Andrei

View solution in original post

2 Replies

Re: Help with a calculation inside a straight table

Perhaps this?

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

, svc, req_date))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Partner
Partner

Re: Help with a calculation inside a straight table

Hi,

Check attached example.

hope this helps.

//Andrei

View solution in original post