Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
dhanavindhan
Creator
Creator

Above Function not working properly

Dear Experts,

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.

For ex:

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

Reg,

Dhana R

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try this;

=interval(SBEDate- above(BOSPDate),'hh'))


View solution in original post

5 Replies
YoussefBelloum
Champion
Champion

Hi,

try this;

=interval(SBEDate- above(BOSPDate),'hh'))


sunny_talwar

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'))

or this

Above(TOTAL Interval(BOSPDate - SBEDate, 'hh'))

dhanavindhan
Creator
Creator
Author

Hi Youssef,

=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.

Reg,

Dhana R

dhanavindhan
Creator
Creator
Author

Hi Sunny,

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.

sunny_talwar

Would you be able to share a sample to show the issue?