Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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.

Community Browser