Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

0 Replies