How to display total runs calculated in every 5 over of a cricket match ?

[shekhar_analyti]

Hi All ,

How to display total runs calculated in every 5 over of a cricket match ?
I used class function but problem is that it segregated 20 over into 5 parts .

Actually it should in 4 parts ; 1-5,6-10,11-15,16-20 .

Though i I used class function .

Thanks & Regards

Shekar

[maxgro · Accepted solution]

you can try with the last parameter of the class function, offset

class ‒ QlikView

something like

=dual(

subfield(class(over,5), '<', 1) +1 & ' - ' & subfield(class(over,5), '<', 3) ,

class(over,5, 'over', 1)

)

[shekhar_analyti]

Hi Massimo ,

Thanks for reply . This worked .

Is there any other way around , apart from using class function .

[maxgro]

if

=if(over <= 5, '1-5',

if(over <= 10, '6-10',

if(over <= 15, '11-15',

if(over <= 20, '16-20'

))))