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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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