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.
I need to take interval between 2 timestamp fields. One of the field will be considered from previous row value. So, I wrote expression like this,
=aggr(above(interval(BOSPDate - SBEDate,'hh')),BOSPDate)*24
in Output filed "Actual Hour's" bringing wrong value.
Pls find my attached screenshot it will give better understanding.
10/07/2018 13:00:00 - 11/07/2018 15:30:00
Ans : 26:30 Hrs
Output in my Field: 19.00 Hrs
Help me to fix this issue. Why I am getting like this?
Note: BOSPDate is previous row field
View solution in original post
I think Above() is not a problem, but the Aggr() is.... why do you need to use Aggr() here? can you just try this
Above(Interval(BOSPDate - SBEDate, 'hh'))
Above(TOTAL Interval(BOSPDate - SBEDate, 'hh'))
=aggr(interval(Voyrep.SBE - above(Voyrep.BOSPDate),'hh'),Voyrep.SBE)*24
Only When I use aggr function I get the answer. Actually I dn't knw how to technically explain that.
Tnx for reply.
After Long back, gud to get reply frm u.
Hope ur doing good!!!!
I really don't knw sunny, only when I use aggr function I am getting the answer.
May be the reason it should be aggregated with any one datefield.
Would you be able to share a sample to show the issue?