Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have feild that show time 1.36(1hour & 36 minute )
if i write in expression sum(feild1) the result is 5.44 (i have 4 line with that 1.36 )
how do i write to get the result in hour - 6.24 - 6 hour & 24 minute ?
thanks'
yarin.
hi
please help me
I could not sum a column.
Thank you for your help
Hi @fgolmahi , I don't have a qv license yet (hoping to get one soon from qlik as an MVP). So can't open your qvw and check what/how you are trying. Please post your expression/ screen shot and expected result w.r.t. the sample data you shared.
Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.
my expression is =Time(Sum(time#(timeee, 'h:mm')),'h:mm')
Hi, thank you for your help
Yes, I use the server version at work and I have no problem opening files.
If possible, please guide me to the field of the attached file.
my expression is =Time(Sum(time#(timeee, 'h:mm')),'h:mm')
I have problem opening the file. I got your expression, now let me know your expected output and what you are getting using the above expression while using the excel data you shared.
Hi @tresesco
Yes, I use this expression, but unfortunately it calculates incorrectly and calculates integer.
please help me 😞
for example sum following fields :
05:09 |
03:32 |
00:41 |
05:01 |
02:44 |
01:17 |
00:00 |
00:40 |
03:48 |
03:13 |
00:48 |
02:50 |
05:05 |
While working on timestamp and it's formatting there are important catches and that is the reason I wanted to emphasis on 'your expected output'. I guess you need interval(), something like:
Interval(Sum(time#(timeee, 'h:mm')),'h:mm')
Or, simply
Interval(Sum(timeee),'h:mm')
Thank you for your help. @tresesco
Your comments were excellent and I able to get the right answer.
Thank you very much.