Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
I will check and get back to you...
Thanks Sunny. Hope will get it. thanks for your help.
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.