topic Re: Above Function not working properly in QlikView

Above Function not working properly

dhanavindhan — Mon, 08 Oct 2018 13:29:36 GMT

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

YoussefBelloum — Mon, 08 Oct 2018 13:36:20 GMT

Hi,

try this;

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

sunny_talwar — Mon, 08 Oct 2018 13:36:55 GMT

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 — Tue, 09 Oct 2018 04:35:25 GMT

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 — Tue, 09 Oct 2018 04:37:06 GMT

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 — Tue, 09 Oct 2018 11:11:20 GMT

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