Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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!