Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

YTD calculation: shows total not YTD?

I am trying to get a YTD calculation to work.

I used examples here:

YTQ, QTD, MTD and WTD

However, it always returns the TOTAL SUM so if I just do SUM(MySalesField) it gets the same result as:

Sum({$<Date = {'>$(=Max(([Fiscal Year](Date)))) <=$(=Max(Today()))'}>} [MySalesField])

or

SUM({$<[Calendar Date] = {'>=$(=YearStart(Today()))<=$(=MonthEnd(Today()))'}>}[MySalesField])

I am not really sure how to parse that.

What I would expect is that with no calendar applied to the visualization I would just get YTD for sales for this current year (2016).

That isn't happening though, I am getting total of ALL sales.

Thanks!

2 Replies
Not applicable

Re: YTD calculation: shows total not YTD?

vinieme12
Not applicable

Re: YTD calculation: shows total not YTD?