How to sum over the month in the backend

[rkpatelqlikview]

Dear Qlik,

PFA sample QVW.

How to do sum calculation in the backend. The values should be changed in the front end like Data as shown in the  Pivot Table.

Thanks

KUMAR

[rkpatelqlikview]

Dear Sunny,

Other wise can i use this in text object to count of drivers whose score is less than 20,

in other text object count whose score is in between 20 and 50 and above 50 count.

=count(distinct ((sum([HB Count])+sum([OVSD Count])+sum([CD Count])+sum([HA Count]) )/ sum([Kms Travelled]) *1000) <=20))

      ((sum([HB Count])+sum([OVSD Count])+sum([CD Count])+sum([HA Count]) )/ sum([Kms Travelled]) *1000) >20 and

      ((sum([HB Count])+sum([OVSD Count])+sum([CD Count])+sum([HA Count]) )/ sum([Kms Travelled]) *1000) <=50,

((sum([HB Count])+sum([OVSD Count])+sum([CD Count])+sum([HA Count]) )/ sum([Kms Travelled]) *1000) >50,

[sunny_talwar]

I will check and get back to you...

[rkpatelqlikview]

Thanks Sunny. Hope will get it. thanks for your help.

[rkpatelqlikview]

Hi Sunny,

Please let me know if you want more information. Please find the attached actual qvw.

I need to show the count of drivers, those are in Green, Yellow, Red and all count.