This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi - I have hours in the below format.When I do sum of hours I get zero.Do I have to convert this format ??
With slight modifications in the script... I am seeing the same result
View solution in original post
Simply Num(FieldName) not working for you?
I mean Sum(Num(FieldName)) is not working for you?
Yes, it would be better if you use Interval() on top of Sum()
Interval(Sum(...), 'D hh:mm:ss')
Thank you all but all these expressions are giving me 3 in Qliksense where as 13 in Qlikview with the same expression.
Should be same in both correct ?
Without seeing qvw and qvf... it would be difficult to say... but the difference could be because of many different things. Just to list few
1) Different field formats
2) Different soruces
3) Different data
4) Different expressions
5) Different environmental variables
Probably you must to convert the time to number with "time#(field, 'hh:mm')", try this.
stalwar1 - I have attached the source file ,QVW & QVF ....
As always you are awesome