Discussion Board for collaboration related to QlikView App Development.
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
you can try with the last parameter of the class function, offset
class ‒ QlikView
subfield(class(over,5), '<', 1) +1 & ' - ' & subfield(class(over,5), '<', 3) ,
class(over,5, 'over', 1)
View solution in original post
Hi Massimo ,
Thanks for reply . This worked .
Is there any other way around , apart from using class function .
=if(over <= 5, '1-5',
if(over <= 10, '6-10',
if(over <= 15, '11-15',
if(over <= 20, '16-20'