Discussion Board for collaboration related to QlikView App Development.
Hi All ,
How to find number of wickets fallen in between the period of any three consecutive overs where runs decreased gradually ?
In season 2008 match id 1 , in the 1st inning , over 7 , 8 and 9 witnessed gradual decrease in RUNS . I need to find number of wicket fallen in between this period .
Note : Field " dismissal_kind " ... gives fall of wicket .
Thanks & Regards
Shekar
Try:
Over | Count(player_dismissed) |
---|---|
6727 | |
Not Declining | 5005 |
Runs Declining | 1722 |
Where Over is the calculated dimension:
=Aggr(
if(
Sum(total_runs) < Above(Sum (total_runs)) AND Above(Sum (total_runs))<Above(Sum (total_runs),2)
OR
Sum(total_runs) < Above(Sum (total_runs)) AND Below(Sum (total_runs))<Sum (total_runs)
OR
Below(Sum (total_runs)) < Sum(total_runs)AND Below(Sum (total_runs),2)<Below(Sum (total_runs))
, 'Runs Declining', 'Not Declining'),over)
Regards
Andrew
stalwar1 .... your expertise needed .
antoniotiman ... please help !
stalwar1 ... Hi Sunny .. please let me know if this requirement is unrealistic and not possible
Hi Shektar,
Try this for the bar background colour:
if(
Sum(total_runs) < Above(Sum (total_runs)) AND Above(Sum (total_runs))<Above(Sum (total_runs),2)
OR
Sum(total_runs) < Above(Sum (total_runs)) AND Below(Sum (total_runs))<Sum (total_runs)
OR
Below(Sum (total_runs)) < Sum(total_runs)AND Below(Sum (total_runs),2)<Below(Sum (total_runs))
, LightRed())
giving
Regards
Andrew
Next time, maybe you should include the rules of the game for cricket. Not really a major sport in either the US or Italy, I guess
Hi Andrew ,
Thanks for the reply , but its not the background colour i was looking for but wanted to find no. of players dismissed between those overs which has gradual decrease in runs for three consecutive overs .
Note : Actually there has been an analysis in cricket that , chances of dismissal increases when a bowler bowls continuous 3-4 overs with less runs . I just wanted to test that .
Thanks & Regards
shekhar
Try:
Over | Count(player_dismissed) |
---|---|
6727 | |
Not Declining | 5005 |
Runs Declining | 1722 |
Where Over is the calculated dimension:
=Aggr(
if(
Sum(total_runs) < Above(Sum (total_runs)) AND Above(Sum (total_runs))<Above(Sum (total_runs),2)
OR
Sum(total_runs) < Above(Sum (total_runs)) AND Below(Sum (total_runs))<Sum (total_runs)
OR
Below(Sum (total_runs)) < Sum(total_runs)AND Below(Sum (total_runs),2)<Below(Sum (total_runs))
, 'Runs Declining', 'Not Declining'),over)
Regards
Andrew
Maybe something like the below
if( (over >=sum(total aggr(DISTINCT if ( (rangesum(Above( (sum(total_runs) < Above(sum(total_runs))) ,0,2))*-1 )=2 and
(rangesum(Above( (sum(total_runs) - Above(sum(total_runs)) ) ,0,2))*-1 )<15 , over ),over ))-2 ) and
( over<=sum(total aggr(DISTINCT if ( (rangesum(Above( (sum(total_runs) < Above(sum(total_runs))) ,0,2))*-1 )=2 and
(rangesum(Above( (sum(total_runs) - Above(sum(total_runs)) ) ,0,2))*-1 )<15 , over ),over )) )
, sum(total_runs))
Hi Andrew ,
Your solution worked perfectly and the colour coding which you had given earlier is like bonus . Just little add on it ..
How to set reference line in the highlighted over where a player got dismissed .
Example in 6th over player SC ganguly got dismissed