Solved: Re: YTD calculations - Qlik Community

Anonymous · ‎2017-07-20

Hello All,

Can this YTD count be achieved by using expressions? Could somebody help?

tresesco · ‎2017-07-20

If you have month as the dimension in a straight table, you could use the same count expression for YTD and enable 'Full Accumulation' in the expression tab itself.

Or, Expression like:

RangeSum(Above(<count expression>,0,RowNo()))

View solution in original post

tresesco · ‎2017-07-20

If you have month as the dimension in a straight table, you could use the same count expression for YTD and enable 'Full Accumulation' in the expression tab itself.

Or, Expression like:

RangeSum(Above(<count expression>,0,RowNo()))

Anonymous · ‎2017-07-20

Thanks for your reply. Could you help me out with the YTD expression as well?

tresesco · ‎2017-07-20

My suggestion above is against YTD expression only. I guess, we could better help if you could share a sample qvw.

tajmohamed30 · ‎2017-07-20

YTQ, QTD, MTD and WTD

Anonymous · ‎2017-07-20

Your earlier suggestion worked. Thanks.