I have this odd timeformat so the time 0.01 is 1 minut, 0.3 is 30 min and 1 is one hour. (With some help I got qv to convert it to decimaltime by dividing with 60 and then decimaltime to hours and min wich ended up to be pretty messy in calculations.
But I was thinking maybe some of you knows a more simply way to do this. In mather in fact the number don´t need to be converted to time because enduser already knows that 28.5 means 28 hours 50 min. So then my question seems to be can I make qlikview to count 0.059 then 0.1, 0.59 then 1 , 1.59 then 2 and so on..? I also think that something like that could solve my problem when time goes over 23 hours it don´t continue to count right. I have understod that the asnwer to that should be Interval() but I havn´t been able to use it in same expression were I convert to hours min.
I will try first thing tomorrow when I´m back at office. So this will work even if the orginal field are 0.01 or 1024.32? The 0.01 are the lowest it can be but it can also be in for example 1024.32 as 1024 hours and 32 min.
Hi marc, yes, that´s what I have tried. I think it was a bit tricky to use it in expression and sum. Maybe I´d it somehow wrong. How would you sum that field or divide it with some other field? I got it work but I think I did it more complecated then it have to be. Thanks again Celambarasan, will try it!
Since the math in qlikview is base 10 (That I am aware of) and time uses base 60 (in the decimal field) the formula I pasted above basically just converts it so instead of 60 being whole, 100 is whole. The hours section is not affected by this conversion since we are not further converting into days.
It´s the Time that are in base 60 as orginal. What will be the best for the load? To first convert it to base 100 and then do the calculation or to do the conversion after the calculation? The calculation gives me a number with many decimal so I gues that the suggested Interval(Interval#(Field,'h.m'),'hh.mm') are not possible?
The If calculation is used to convert the time from time per day and time per month to time per week. Jcount is 1-7 as weekdays. Period are a number of how many times it occurs, 2 in period and week in unit are equal to every second week as are day in unit and 7 in JCount are equal to every day and so on.