Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

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

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 .

class.PNG

Thanks & Regards

Shekar

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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)

)

View solution in original post

3 Replies
maxgro
MVP
MVP

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)

)

View solution in original post

shekhar_analyti
Specialist
Specialist
Author

Hi Massimo ,

Thanks for reply . This worked .

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

maxgro
MVP
MVP

if

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

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

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

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

))))