Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Convert Hour into Number figure

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

3 Replies

Re: Convert Hour into Number figure

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

Re: Convert Hour into Number figure

Hour(yournumber)

Re: Convert Hour into Number figure

Hi,

Try

Num(Num#(HourField))

regards

Regards,
Prashant Sangle
Community Browser