Trailing Twelve Months on Bar Graph

Thu, 24 Apr 2014 21:08:03 GMT

I would like to create a bar graph showing the previous 12 months of (LineSalesAmount) for each month year on the bar graph. I have pasted my current iteration here. I am currently running the calculation in the expression field of the bar graph as shown below. The issue is that the chart is only summing data for which is shown on the graph. I.e. in this example, I would like to exclude April 2012, because there are only 4 months of data available. Is there any way to exclude Month-Years for which there is less than a full year of LineSalesAmount Data? Pictures of the chart and the script are below.

Thank you so much in advance!

Re: Trailing Twelve Months on Bar Graph

Thu, 24 Apr 2014 21:09:00 GMT

Here is the Expression script as mentioned above.

Re: Trailing Twelve Months on Bar Graph

Fri, 16 May 2014 22:52:05 GMT

Hi Marian,

do you still need help in this subject?

regards

Darek

topic Re: Trailing Twelve Months on Bar Graph in QlikView

Trailing Twelve Months on Bar Graph

Re: Trailing Twelve Months on Bar Graph

Re: Trailing Twelve Months on Bar Graph