forecasting for cussrent as well as next 5 years

[Anonymous]

Hello everyone,

i want to show forecasting for current as well as next 5 years.

i am not getting how to write line style for next years. i have used below line style for current year.

It shows current year forecasting but for next five years i don't know how to write expression?

please help me to find out solution.

Thanks..

[tresesco]

May be like:

=If( NA_YEAR>Year(Today()) and NA_YEAR<=Year(Today())+5 , '<s3>','<s1>')

[Anonymous]

i  have show  like  when  i  click  on  year  2018 it  will  be  show  forecasting  for  2018  to  2023  (continuously) .

by  using  your  expression  it  show  forecast  for  current+5  but  not  showing  continuously .  it  means  when  i  click   on  year  18  then  its  shows  forecasting  for  18  when  i  click  on  19  then  it  show  for  19  &  so  on.

[tresesco]

This selection behavior could be altered using set analysis in expression. Try to share a sample qvw that shows what and how expression is being used in your chart, so that we can suggest accordingly.

[Anonymous]

PFA ,

please refer 2nd chart (dummy data)

[tresesco]

Could you explain the issue a bit more with reference to the chart shared?

[Anonymous]

its dummy data so its not showing exactly issues which i face in real app.

in my application yore expression is working but the thing is its not showing continuously forecasting.

my requirement is when i click on 2022 then chart will be show forecast for year 18 to 22.

but by using your exp its shows forecast only for selected years.

[tresesco]

Try to create the dummy data such that it can reproduce the issue of your actual app.

[Anonymous]