YTD not working

guillaume_gorli — Tue, 10 Jul 2018 09:17:12 GMT

Dear all,

Please see below simple database with :

Date

Sales

Salesman

I need to produce two outpout.

First output is a table showing per month, the monthly sales value as well as the year to date sales.

No issue here as you can see below :

Second output is a table showing per salesman the monthly sales as well as the year to date sales. This is where my ytd figures is not tying :

What i gor from YTD figures if December 2018 is selected is :

123 for Chris

248 for Franck

365 for Roger

Although what i should get is :

123 for Chris

125 for Franck

117 for Roger.

The formulas used is "RangeSum(Above(Sum({$<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Mois, [Année]>}Sales), 0, RowNo()))" with Salesman as dimension.

Attached are qvw and excel test database for the ones who may help

Thanks in advance

Guillaume

Re: YTD not working

sunny_talwar — Tue, 10 Jul 2018 11:42:21 GMT

Since you are not using date/Month/Year as a dimension anymore... you don't need RangeSum(Above()) here... try this

Sum({$<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Mois, [Année]>}Sales)

Re: YTD not working

guillaume_gorli — Tue, 10 Jul 2018 13:05:17 GMT

Thanks a lot.

Working perfect

topic Re: YTD not working in QlikView

YTD not working

Re: YTD not working

Re: YTD not working