topic Re: Convert number to time in format hh:mm:ss in QlikView

Convert number to time in format hh:mm:ss

Thu, 11 Jul 2013 13:20:30 GMT

Dear qlikview users,

I'm developing a dashboard where the gasconsumption over time is visible. One must be able to filter out the data by selected a time range.
This must be done for 3 expressions in one chart. So a user can select 3 different time ranges. I'm using 3 sliders for selecting the timerange.

My expression is as follows:

Sum({<Category = {'GA1'}, Hour ={">=$(v_num_shift1_min) <=$(v_num_shift1_max)"}>}[Total value])

The field "Hour" stands for the time and has the format: hh:mm:ss

The variables v_num_shift1_min and v_num_shift1_max indicates the minimum and maximum values. My slider shows the whole hours: 1,2,3 etc.

A sample value of one of the variables: 0,08333. I want to convert this number value in the format hh:mm:ss, so that my expression can work.

Re: Convert number to time in format hh:mm:ss

swuehl — Thu, 11 Jul 2013 13:32:56 GMT

Try

Sum({<Category = {'GA1'}, Hour ={">=$(=Time(v_num_shift1_min)) <=$(=Time(v_num_shift1_max))"}>}[Total value])

or with explicite format code:

Sum({<Category = {'GA1'}, Hour ={">=$(=Time(v_num_shift1_min,'hh:mm:ss')) <=$(=Time(v_num_shift1_max,'hh:mm:ss'))"}>}[Total value])

Re: Convert number to time in format hh:mm:ss

Thu, 11 Jul 2013 13:37:44 GMT

try this

Sum({<Category = {'GA1'}, Hour ={">=$(=Time(v_num_shift1_min,'hh:mm:ss')) <=$(=Time(v_num_shift1_max,'hh:mm:ss'))"}>}[Total value])

or try this

Sum({<Category = {'GA1'}, Hour ={">=$(=Date(v_num_shift1_min,'hh:mm:ss')) <=$(=Date(v_num_shift1_max,'hh:mm:ss'))"}>}[Total value])