Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

I'm new to qliwview was asked this question in a job interview

Qlikview’s timestamp is a real number. The integer is the number of days from a given date (1899-12-30) the remainder is time. It is often necessary to work with the Qlikview timestamp, normally using the time for one purpose or another, so it is necessary to know how to convert time to Qlikview’s timestamp. This is done as follows: To calculate 1 second you simply divide 1 by 24 to give you hours then by 60 to give you minutes and finally by 60 again to give you seconds i.e. 1 / 24 / 60 / 60.

Knowing this you are given a timestamp, you are asked to remove 2H30 from the time, and then return only the time (i.e. the remainder) from the real number. Explain how you would do this using basic programming methods.

Please assit me with answers thank you

1 Reply
MVP
MVP

Re: I'm new to qliwview was asked this question in a job interview

this is not much about qlikview, but more about simple maths. taking your 2H03 as 2hour 30mins, you are asked to substract this from a given timestamp.

qv6.png

See, the first part with '-' for 30 mins, and the second one for 2 hours. Note 1 means a day.

Hope this helps.

Community Browser