How to compute 1/Feb - Today Amount by year ?

paulyeo11 — Wed, 24 Feb 2016 16:42:13 GMT

Hi All

I have this expression is working fine , it will display YTD sales by year ( Jan and Feb ) :-

money(sum(-$(ColumnDim51)/$(Columndim89) * YearToDate(date, year-Year(Today())))/1000,$(vMoneyFormatK))

Now it display :-

Examople now is 24/2/16 :-

1st bar will display 1/1/16 - 24/2/16

2st bar will display 1/1/15 - 24/2/15

3st bar will display 1/1/14 - 24/2/14

As i need to display Current month Feb 2016 MTD sales.

May i know how to modify the above expression , only Feb month to date sales.

Examople now is 24/2/16 :-

1st bar will display 1/2/16 - 24/2/16

2st bar will display 1/2/15 - 24/2/15

3st bar will display 1/2/14 - 24/2/14

Hope some one can help me.

Paul

topic How to compute 1/Feb - Today Amount by year ? in QlikView