Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Difference

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

1 Reply

Re: Date Difference

See attached qvw.


talk is cheap, supply exceeds demand
Community Browser