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 ,


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?


1 Reply

Re: Date Difference

See attached qvw.

talk is cheap, supply exceeds demand
Community Browser