Show next two year from dimension based on selection of 1.

[Qlik1_User1]

HI,

Please help with logic.

Year, amount

2024,1

2025,2

2026,3

2027,4

If user select 2025 which is current year than in bar chart
data should come for year 2025, 2026, 2027

Else for selected year , data should come. please suggest

[QFabian]

Hi @Qlik1_User1 , here you have an option, basically, it creates a new Year field and a couple of variables to do it.

Script:

Data:

Load * INLINE [

Year_Field, Amount_Field

2024,1

2025,2

2026,3

2027,4

];

Year_Field_2:

Load 

distinct Year_Field as Year_Field_2 

Resident Data;

Chart Expression

if(Year_Field_2 = $(vYear),
{<Year_Field = {">=$(vYear)"}>}
Sum(Amount_Field)
,
{<Year_Field = {"$(vYear_2)"}>}
Sum(Amount_Field)
)

Variables :

vYear = =year(today())

Year_Field_2 = Year_Field_2

Attached the working QVF  example