Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
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).
Thank a lot.
N.
Perhaps this?
If(Interval(FieldName, 'd')<>0, Interval(FieldName, 'd hh:mm:ss'))