is it possible to show the day in time format only if it is greather then 0?
eg:
in the formatting pattern of the QlikView chart properties I set d hh:mm:ss and it shows both 1 10:12:50 and 0 15:12:27 (I'd like to omit the day when it's equal to 0).
You can use the Interval function to format the value: If (MyValue <1 , Interval(MyValue, 'h:mm:ss'), Interval(MyValue, 'd h:mm:ss')) You'll need to set the format option in the Qlikview chart to Expression default.
You can use the Interval function to format the value: If (MyValue <1 , Interval(MyValue, 'h:mm:ss'), Interval(MyValue, 'd h:mm:ss')) You'll need to set the format option in the Qlikview chart to Expression default.
If(Interval(FieldName, 'd')<>0, Interval(FieldName, 'd hh:mm:ss'))
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
