Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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'))


View solution in original post

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?