topic Re: Date Difference in QlikView

Date Difference

Tue, 01 Jul 2014 07:30:48 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

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

Anonymous — Tue, 01 Jul 2014 07:39:34 GMT

Hi,

I didn't exactly understand your requirement but below may help you,

Statement Date

31/12/2000

31/12/2003

31/12/2001

31/12/2005

Missing Year

2002

2004

Convert Missing Year in date format "Date(Date#([Missing Year], 'YYYY')) as Missing Year Date" and

If([Missing Year Date]-[Statement Date]>=730, Values)

Thanks

Re: Date Difference

mahesh_agrawal — Tue, 01 Jul 2014 08:06:59 GMT

Hi Senthil,

Find the attached Excel file and QVW file.

I hope it addresses your problem.