Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Generate List of End Dates

I have a Calendar table which each Fiscal Year/Period is linked to a date range. For example, Fiscal Year / period 2019002 has dates range from January 29th 2018 to March 4th 2018. I want to create a table with only the date end of each Fiscal Year Period. Is there a way to use Where to extract those dates ? Thank you for your help.

LOAD  Date_DATE0, 

           [Fiscal year / period_FISCPER]

FROM

(qvd)

Where ;

FYPeriod.JPG

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps like this:

LOAD

          [Fiscal year / period_FISCPER],

          Date(Max(Date_DATE0)) as Date_DATE0

FROM

    

     (qvd)

GROUP BY

     [Fiscal year / period_FISCPER]

     ;


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
ziadm
Specialist
Specialist

Please send a sample data

Gysbert_Wassenaar

Perhaps like this:

LOAD

          [Fiscal year / period_FISCPER],

          Date(Max(Date_DATE0)) as Date_DATE0

FROM

    

     (qvd)

GROUP BY

     [Fiscal year / period_FISCPER]

     ;


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thank you very much Gysbert.