topic Date problem in QlikView

Date problem

Fri, 14 Nov 2014 13:36:52 GMT

Hi All,

I am new to Qlikview so excuse me if this question is really simple.

I have used following function which seems to work quite well:

If([Revised Due Date]<=today()-61,[Line Debt],0)

I tried to replace today's date with the specific date or end of the month date but it doesn't give me correct results.

Could you please help??

MK_QSL — Fri, 14 Nov 2014 13:37:36 GMT

how you tried? Can you post the expression pls?

Fri, 14 Nov 2014 13:41:39 GMT

I have tried:

If([Revised Due Date]<=30/11/2014-61,[Line Debt],0)

and all sort of combinations with monthend expreccion.

kristoferahlin — Fri, 14 Nov 2014 14:03:29 GMT

The problem is most likely with the date format. You might want to try something like:

If([Revised Due Date]<= Date(Date#('30/11/2014', 'DD/MM/YYYY')-61, 'DD/MM/YYYY'),[Line Debt],0)

You might want to consider putting end of month in a variable, like vMonthEnd = MonthEnd(Today()). Then use that variable in your expression.

Fri, 14 Nov 2014 14:12:03 GMT

Thank you very much for your help.

I've been trying to work it out myself for two days

It pays off to ask for help.