Display data by alternate years in bar chart

[analyticsuser]

Hi,

 I'm trying to display data in a bar chart on alternate years and stuck with the expression. Seeking all Qlik experts help for a solution. 

the attached document has the logic on how the data should be displayed. 

[eddie_wagt]

Hello,

Does this meet your requirements?

1. Determine which year is selected by using function subfield(GetFieldSelections(Year),',',-1)

2. Put this function in a variable vYearSelected

3. Use this set analysis in your chart: =sum({$<Year={"<=$(vYearSelected)"}>}Sales)

Hope this helps

Regards 

Eddie