Problems on YearToDate

marcel_olmo — Mon, 15 Apr 2013 13:22:19 GMT

Hi guys,

if I have a table like this :

I'd like to have a simple table with two expressions :

1- Total amount of sales.

2-YearToDate of amount of sales.

I've been trying to do it with a yeartodate set analysis I've found on the forum :

Year to Date = Sum({<Datefield={'>=$(=(Num(YearStart(Max(Datefield)))))<=$(=(Num(Datefield)))'}>}Sales)

And it works fine if no month is selected. But If I select, for example, february, I get this :

When the correct table is :

Any idea about how to solve that? I'm trying to avoid "alternate states". I hope it won't be necessary.

Many thanks in advance.

Regards, Marcel.

topic Problems on YearToDate in QlikView