topic Re: Cricket innings chart in QlikView

Cricket innings chart

Anonymous — Tue, 09 Sep 2014 11:33:00 GMT

Hi, I have attached cricket innings document. I am not able to calculate the cumulative score. I used the following expression : RangeSum(Above(sum(Runs),0,RowNo())). Can anyone tell me how to calculate run rate and rate/5 over.

Re: Cricket innings chart

Anonymous — Tue, 09 Sep 2014 11:41:09 GMT

Your Expression is correct....

Is there any error/ issue that your are notable to get desired results........

Re: Cricket innings chart

anbu1984 — Tue, 09 Sep 2014 11:47:17 GMT

Can you attach sample app

Re: Cricket innings chart

MK_QSL — Tue, 09 Sep 2014 11:55:35 GMT

Load Below script...

LOAD Over,

F2,

SubField(Score,'/',1) as RunsPerOver,

Score,

Runs,

[Run Rate],

[Rate/5ov],

F7,

Score1,

Runs1,

[Run Rate1],

[Rate/5ov1],

[Rate Req],

[Runs Req],

[Balls Rem]

FROM

[http://www.espncricinfo.com/england-v-india-2014/engine/match/667727.html?view=comparison]

(html, codepage is 1252, embedded labels, table is @53, filters(

Remove(Row, Pos(Top, 1))

));

==============

Create a straight Table

Dimension

Over

Expression

For RunRate

RangeSum(Above(SUM(Runs),0,RowNo()))/Over

For RunRate of Last 5 overs

IF(RowNo() < 5, Null(), RangeSum(Above(SUM(Runs),0,5))/5)

UPDATE:

Or you can use below expression also...

For RunRate

RangeSum(Above(SUM({1}Runs),0,RowNo()))/Over

For RunRate of Last 5 overs

IF(RowNo() < 5, Null(), RangeSum(Above(SUM({1}Runs),0,5))/5)

Re: Cricket innings chart

MK_QSL — Tue, 09 Sep 2014 14:19:46 GMT

Like this?