topic Multiple Years in a chart in QlikView

Multiple Years in a chart

Mon, 01 Apr 2013 18:02:43 GMT

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.

Re: Multiple Years in a chart

Anonymous — Mon, 01 Apr 2013 18:20:01 GMT

Try this

=Sum({$<%Dim_Id = {TLNR}, Cal_Fiscal_Year = {$(=Max(Cal_Fiscal_Year)), $(=Max(Cal_Fiscal_Year)+1)}>} Actual_Amt)

Re: Multiple Years in a chart

Mon, 01 Apr 2013 18:58:15 GMT

This still only gives me a single bar for the currently selected year.

Re: Multiple Years in a chart

Anonymous — Mon, 01 Apr 2013 19:00:32 GMT

What is the year you have selected? And, what is the highest year available?

The expression will use the year selected and the next highest year. If that is not the issue then it could be another property setting in the chart.

Re: Multiple Years in a chart

Mon, 01 Apr 2013 19:05:47 GMT

I think this will work. I beleive my problem is in my select list. I thought I could join on a different code that what was in my select list.

Re: Multiple Years in a chart

Anonymous — Mon, 01 Apr 2013 19:29:53 GMT

May not need it but I'd already put it together by the time I saw your reply.....see attached.