Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw.


talk is cheap, supply exceeds demand