Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sudhir0538
Creator
Creator

Calculating Average

Hello Guys, I've 5 rating fields for every vendor transactions. I need to identify the average of these 5 fields against that vendor. How Can I achieve this through script?

Samples attached 

sudhir0538_0-1604550423369.png

Column (G) is to achieve that is the average of Column (H,I,J,K,L). I've achieved this in chart by sum()/5. But how can i achieve this in script.

Thanks in advance.

 

 

1 Solution

Accepted Solutions
MayilVahanan

Hi @sudhir0538 

Hope all fields are coming from same table, in that case, you can do like below

RangeAvg(Field1,Field2,Field3,Field4,Field5) as FieldName

or

(Field1+Field2+Field3+Field4+Field5) / 5 as FieldName

Thanks & Regards,
Mayil Vahanan R

View solution in original post

1 Reply
MayilVahanan

Hi @sudhir0538 

Hope all fields are coming from same table, in that case, you can do like below

RangeAvg(Field1,Field2,Field3,Field4,Field5) as FieldName

or

(Field1+Field2+Field3+Field4+Field5) / 5 as FieldName

Thanks & Regards,
Mayil Vahanan R