Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

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

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