Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Peony
Creator III
Creator III

How to reduce minus sign for duration values in a symmetrical bar chart

Hi all.
I know that in order to remove the minuses fro the lest part values I need to change the format of the pattern. But I don’t know how to do it for the duration. Could someone help with it, please?

 

barchart.png

1 Solution

Accepted Solutions
lorenzoconforti
Specialist II
Specialist II

In number formatting, select measure expression

then, in your expression, use the dual function; something along these lines (the first element will be displayed as part of the label, the second is the actual number used to put the bar chart together):

dual(interval(fabs(Avg(YourMeasure)),'h:mm:ss'), Avg(YourMeasure))

View solution in original post

2 Replies
lorenzoconforti
Specialist II
Specialist II

In number formatting, select measure expression

then, in your expression, use the dual function; something along these lines (the first element will be displayed as part of the label, the second is the actual number used to put the bar chart together):

dual(interval(fabs(Avg(YourMeasure)),'h:mm:ss'), Avg(YourMeasure))

Peony
Creator III
Creator III
Author

Thank you, Lorenzo. It works!