topic Re: Day/Time formatting in QlikView

Day/Time formatting

Nino — Sun, 19 May 2019 07:33:49 GMT

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.

Re: Day/Time formatting

Gysbert_Wassenaar — Sun, 19 May 2019 08:13:54 GMT

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.

Re: Day/Time formatting

Anil_Babu_Samineni — Sun, 19 May 2019 15:09:02 GMT

Perhaps this?

If(Interval(FieldName, 'd')<>0, Interval(FieldName, 'd hh:mm:ss'))

Re: Day/Time formatting

Nino — Tue, 21 May 2019 16:26:10 GMT

I've found some problems by testing Interval(FieldName, 'd')<>0.
Thank you the same for the suggestion

Re: Day/Time formatting

Nino — Tue, 21 May 2019 16:26:28 GMT

Excellent!

Thank you so much!