Re: Convert Hour into Number figure - Qlik Community

Report Inappropriate Content · ‎2015-06-02

Hello All,

I would like to convert 5 hours in qlikview into 5 as a number.

I do not want to convert it into 0,208333333333333.

Is it possible?

Thanks,

Hasvine

Anonymous · ‎2015-06-02

Multiply your Hour field that is in QlikView time format by 24.

MarcoWedel · ‎2015-06-02

Hour(yournumber)

PrashantSangle · ‎2015-06-02

Hi,

Try

Num(Num#(HourField))

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂