Date Difference

Tue, 01 Jul 2014 07:33:41 GMT

Hi All

Please find the attaced excel for data .

My Requirement is - I have to check for the Statement Date and Period Type.

In the excel , we have to check the Statement Date ,

31/12/2000

31/12/2003

31/12/2001

31/12/2005

My Period Type should be 'Year End'

Here the Year 2002, 2004 is missing . and i should similarly find the years missing and if the date difference between the missed year is >= 730 days , i should display the values..

How it can be achieved?

Thanks

Re: Date Difference

Gysbert_Wassenaar — Tue, 01 Jul 2014 10:07:52 GMT

See attached qvw.

topic Date Difference in QlikView

Date Difference

Re: Date Difference