one example using the proposed dual()-function could be:
=Dual(Replace(Replace(Interval(Sum(DURATION_MINUTE)*'00:01:00','dj hh @ mm $'),'@','h'),'$','min'),Sum(DURATION_MINUTE)*'00:01:00')
hope this helps
QlikCommunity_Thread_163843.qvw 151.5 K
That seems to be the good solution indeed. I didn't know this function. Very flexible!
Now, there is still a last issue: in the graphs, the scale is displayed with the numeric value (that's pretty logical as the graph itself is built with numeric), not the formatted value.
Do you see any way to force the scale to be displayed as the formatted value?