Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

paulyeo11
Valued Contributor II

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

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

3 Replies
paulyeo11
Valued Contributor II

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

My QS doc

MVP
MVP

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

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

paulyeo11
Valued Contributor II

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

Hi Sunny

Sorry i file attach the file again.