Discussion Board for collaboration related to QlikView App Development.
good afternoon, I would like to know what function I can use to convert the hours from the database that comes in centesimal to the sexagesimal time format.
I need to perform an average time calculation. However the average that it brings is centesimal i'm using it this way currently
Have you solved this by yourself ?
If you don't, please refer to previous post on this subject.
For example: https://community.qlik.com/t5/QlikView-App-Development/Calculate-time-difference-between-timestamps-...
In general, we can say that Qlikview treatment for time calculation uses special functions.
Did you try: interval(avg (EMX_HORAS_ACUMULADAS), 'Format')