Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

YTD Calculation

Hi All,

I have to show YTD Sale on the basis of selection.

If user Year = 2016 and Month = 5

YTD should show summation of Month = 1,2,3,4 and 5.

My expression is :

sum({<CstFiscalPeriod <= {'$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}>} UnitActual)

But it is throwing error.

Please help.

Thanks,
Sarif

1 Solution

Accepted Solutions
Highlighted

Re: YTD Calculation

May be try this:

Sum({<CstFiscalPeriod = {'<=$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}>} UnitActual)

View solution in original post

1 Reply
Highlighted

Re: YTD Calculation

May be try this:

Sum({<CstFiscalPeriod = {'<=$(=$(vMaxMonth))'}, CstFiscalYear = {'$(=$(vMaxYear))'}>} UnitActual)

View solution in original post