Rounding of the duration format is different depending on the object

[Carreaucaro14]

Hello,

I created a new measure in the master items about working time. 

I use this master item in multiple object for tests.

For a particular case my result should be 22:16.

But the result depend on the object i choose (22:15 vs 22:16).

"22:15" : Combo chart, distribution plot, waterfall chart

"22:16" : bar chart, KPI, line chart, gauge, treemap, circular reference, bullet chart

Some of results are not the same between the result on the object and the tooltips.

Moreover, for example, on the combo chart, the result on the graph is  = 22:15. But if i click on "Show data" the result is = 22:16

Does anybody have an explanation ?

Thank you,

Caroline JEHANNIN

[Carreaucaro14]

I didn't use customized format but duration format. I checked every settings (of two differents objects where the result is different) that you listed but nothing get my attention. Settings are the same.

I already try to compare results without any format and for both objects the result is the same : 0.9277777777778. Then, when I apply duration format results are 22:15:59 vs 22:16:00.

I try to apply duration format on this result in excel and result is 22:16:00.

"0.9277777777778" is the entier result, i didn't apply round in Qlik.

But, I tried to interract in different ways with this data. I have the impression that according to the object the result isn't use in the same way (for the following results i didn't use my calculation, just the result)

For the first object : if i use the result 0.9277777777778 then the result in duration format is 22:16:00

For the second object : if use the result 0.9277777777778 then the result in duration format is 22:16:00

For the first object : if i use the result 0.927777777777 then the result in duration format is 22:15:59

For the second object : if use the result 0.927777777777 then the result in duration format is 22:15:59

If i use my calculation (sum(PRO_001_TEMPS_TRAVAIL_ESTIM)):

For the first object : the result in duration format is 22:15:59

For the second object : the result in duration format is 22:16:00

So i found a solution for having the same results between those 2 objects : interract with rounding in my measure. Then my calculation now is : interval(round(sum(PRO_001_TEMPS_TRAVAIL_ESTIM),0.00000000001), 'hh:mm')

Thank you everyone for your help.