I am trying to create a chart with the following requirements.
Based on the month and year of Returns selected by the user e.g Feb as ReturnsMonth and 2007 as ReturnsYear, the chart need to display the sum of shipments for last 15 months.
There are two tables. The Returns table (containing return_date column) and Shipments table. Shipments table is loaded as shown above.
I created a chart with first dimension as ReturnsYear, second dimension as ReturnsMonth. The expression should calculate Sum(TotalShipped) for last 15 months. Can someone please guide me how to build this expression? I am fairly new to Qlikview and was hoping that this can be accomplished without using set analysis.