Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
paulcalvet
Specialist
Specialist

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 (1)
0 Replies