# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for
Did you mean:
Creator

## Show 3 Fiscal Years Trend

Hi experts!

I want to show a 3 Fiscal Year(FY) trend on multiple line chart.

I have a data columns in my excel telling me the fiscal year the transactions is, but I am not sure how to show 3 FY  trend.

Here, it is showing me 4 FY trend, which is what I have in my excel data. Now I only want to  show 3 FY ( Current FY and pas 2 FY)

How do I script it to show only 3 FY?

Regards,

Frederic

1 Solution

Accepted Solutions
Champion III

Add something like below in set analysis that says

fyear = {">\$(=Max(fYear)-3)"}

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
4 Replies
Champion III

Add something like below in set analysis that says

fyear = {">\$(=Max(fYear)-3)"}

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Champion III

Qlik Community Tip: Marking Replies as Correct or Helpful

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Creator
Author

Hi, where do I add this in as I already have a measure?

Champion III

You need to use this on a numeric Year field

the above set translates to; example

fyear = {">\$(=Max(fYear)-3)"}

fYear = > (2017 - 3);  ie fYear > 2014 .......so in your chart you will see data for year 2015,2016,2017

fyear  should be a numeric year field with values like 2014,2015,2015 etc..

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Tags
Community Browser