How to do the YTD Report ?

[suvechha_b]

Hi All ,

How to create Month and YTD Report like below image.

I have attached the Qlikview Model . Is the report correct for the 1st Month Report.

How to do the YTD Report ?

[#2]

Hi Use Set expression in your expression with date range (YTD Date Range)

[susovan]

Hi Suvechha,

You can try this expression for 'PY Actual'

=Sum(Aggr(if(Measure='Quantity',SUM({<[Fiscal Year]={"=$(vPrevFiscalYear)"},[Type Indicator] = {'A'} >} Quantity),SUM({<[Fiscal Year]={"=$(vPrevFiscalYear)"},[Type Indicator] = {'A'} >} [Sales Value])),  Measure, Month))