topic How to insert filter last 2 yr into my expression ? in QlikView

How to insert filter last 2 yr into my expression ?

Fri, 07 Mar 2014 13:54:10 GMT

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 — Fri, 07 Mar 2014 13:56:40 GMT

money(

Sum(

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

sales/$(Columndim89)/1000)

, $(vMoneyFormatK))

Fri, 07 Mar 2014 13:57:46 GMT

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 — Fri, 07 Mar 2014 13:58:24 GMT

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 — Fri, 07 Mar 2014 14:05:17 GMT

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...