Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

YTD value from not regular calendar

Hello Folks,

I am facing an issue while deriving value for YTD. My scenario is like blow.

Ex: Fiscal Year 2017 starts from July 1, 2016 and ends on June 30, 2017. So range of months is from July 16 to June 17.

I need to get YTD value from start month to last moth which is value from start month July 2016 to May 2017 only.

I can consider min(month_column) as start month but I am unable get value till last month dynamically.

Can anyone help me out.

0 Replies