Convert time value into Qlikview

pranubitla — Wed, 13 Jan 2016 17:58:00 GMT

Greetings,

I am struggling here to write the below SQL calculation in QlikView. please suggest

1. Time:

=IIF(Fields!Time.Value\60 < 10, "0" + CStr(Fields!Time.Value\60), CStr(Fields!Time.Value\60))

+ ":" +

IIF(Fields!Time.Value mod 60 < 10, "0" + FormatNumber(Fields!Time.Value mod 60,0), FormatNumber(Fields!Time.Value mod 60,0))

----------------------------------------------------------------------------------

2. Total:

=IIF((Sum(Fields!Time.Value)\60) < 10, "0" + CStr(Sum(Fields!Time.Value)\60), CStr(Sum(Fields!Time.Value)\60))

+ ":" +

IIF((Sum(Fields!Time.Value) mod 60) < 10, "0" + FormatNumber(Sum(Fields!Time.Value) mod 60,0), FormatNumber(Sum(Fields!Time.Value) mod 60,0))

Re: Convert time value into Qlikview

sunny_talwar — Wed, 13 Jan 2016 18:02:34 GMT

Not an expert in SQL, but seems like you might be able to use Interval() function -> QlikView ‒ Interval - script and chart function