How to insert filter last 2 yr into my expression ?

[#1]

Hi All

I want to add filter for display Current year and Previous year only.

My expression (A)  is :-

money(

Sum(sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

For filter last 2 year , the code is :-

Year={">$(=year(today())-2)

My Question is how to insert the above to Expression (A) ?

[Gysbert_Wassenaar · Accepted solution]

money(

Sum(

{<Year={'>$(=year(today())-2)'}>}

sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

[#3]

Hi All

Forget to explain my Objective. my chart now display many year sales line. i want to make it display current year and previous year.

Enclosed is my QV doc

[alexandros17]

You can do in this way

money(Sum(if(Year>=year(today())-2 ,sales,0)/$(Columndim89)/1000), $(vMoneyFormatK))

or in this way

money(Sum({$ <Year={'>$(=year(today())-2)'}> }sales)/$(Columndim89)/1000), $(vMoneyFormatK))

Hope it helps

[MK_QSL]

Change your Year Dimension to Calculated Dimension as below..

=IF(Year = Year(Today()) or Year = Year(Today())-1, Year)

Don't forget to tick Suppress When Value is NULL..

Hope this helps...