5 Replies Latest reply: Apr 1, 2013 3:29 PM by Curt Daughtry RSS

    Multiple Years in a chart

      I want to create a bar chart that shows the columns as: Previous Year Selected, Selected Year, Next Year from Selected.  I have been playing with set analysis, but can not seem to get it correct.  Here is my attempt at getting the current selected year and the next year. 

       

      =Sum({$<%Dim_Id = {TLNR}, Cal_Fiscal_Year += {$(=Max(Cal_Fiscal_Year)+1)}>} Actual_Amt) , which only ends up showing the currently selected year.

       

      I am fairly new to Qlikview.

       

      Thank you.