Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

Rangesum problem in barchart

Hello,

I have a problem with rangesum(above

My dataset is :

MachineEM5 Zone brossage
Année/Semaine(RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo())))(RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1)(RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) / (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1)
2020/019.1419.14
2020/0210.86130.835384615
2020/0352.22202.611

 

MachineEM5 Zone sablage
Année/Semaine(RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo())))(RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1)(RangeSum(Above(Sum([Temps de bon fonctionnement]), 0, RowNo()))) / (RangeSum(Above(Sum([Nb pannes]), 0, RowNo()))+1)
2020/019.1419.14
2020/0214.5343.6325
2020/0358.1478.305714286

 

But when I put the formula in red in a barchart, I have this values : 

 

For the machine EM5 Zone sablage, I have 4.61 !

If I select this machine, I have the value 8.31 which is the good value (the same value than in the table) :

rangesum2.PNG

I haven't this problem when I select the other machine 😞

please help !

Labels (2)