=if(Year_n < 2, Year) How to make it display recent last 2 year ?

[paulyeo11]

Hi All

In order for me to display 2 bar , i use below expression :-

=if(year > 2014 , year)

As i want to make it more dynamic , i change the expression to :-

=if(Year_n > 1, Year)

But when i need is show 2016 and 2015. Now it show 2014 and 2015.

Paul

[paulyeo11]

My QS doc

[sunny_talwar]

Can't find the reference to the if statement. Have your attached the correct qvw file?

[paulyeo11]

Hi Sunny

Sorry i file attach the file again.