topic Re: Computation with dates in QlikView

Computation with dates

Fri, 21 Aug 2015 06:07:05 GMT

Hello,

I hope some can help me with may question.

I try do compare Dates and bring into a seperate column the result like delay or in time. As you can see from the short Picture it Looks ok, but the last record say late but the Plan date is in the future!

I believe this is coming because the field is empty in the database. So how can I say in an Expressen:

The Formular obove explained should run, but If this field is empty please compare today with the plan and give me a result like in time or delay?

I hope ist understandable what I try to do.

Thank you in advance for your help Regards

Heiko

Re: Computation with dates

sunny_talwar — Fri, 21 Aug 2015 06:47:48 GMT

Try this:

If(Len(Trim([Cut Out 1st])) = 0, Today(), [Cut Out 1st]) - [Cut Out Plan]

To calculate the difference. And may be this to find late or not late

If((If(Len(Trim([Cut Out 1st])) = 0, Today(), [Cut Out 1st]) - [Cut Out Plan]) > 0, 'Late', 'In Time')

Re: Computation with dates

maxgro — Fri, 21 Aug 2015 16:44:18 GMT

if you have null in [Cut Out 1 st] you can also use the alt function

if( [Cut Out Plan] >= alt([Cut Out 1st], Today()), 'In Time', 'Late')

Re: Computation with dates

Mon, 24 Aug 2015 05:59:57 GMT

Hello,

thx for your help. I solved it at the moemnt with the isnull function. So I said

if (isnull(Cut Out 1st),
if (Cut Out Plan >= today(), 'in time', 'delay' )

Regards

Heiko