How to calculate an average based on the list box ?

Thu, 15 Oct 2015 15:22:50 GMT

Hello,

I created the attached line graph where I show the stock by month (one line for budget one for actual) and on the title of the graph I calculate the YTD average (for the actual and for the budget) on the title of the graph according to a variable "currentmonth" that says which is the YTD month. The expression is below:

num(sum(if([Month HFM]<=currentmonth,[Budget Stock standard]/currentmonth)),'# ##0,0')& ' M€ Avge. Actual '& num(sum([Actual Stock standard]/currentmonth),'# ##0,0')& ' M€'

When there is no selection in the "Month HFM" listbox (which shows months 1 to 12) is done it works. But I also want people to use this listbox to show only certain months, and I want the averages in the title to adapt too. If I leave the expression as it is, it will divide the sum of the stocks of the selected month by the current month, not by the months selected in the list box showing the 12 months available.

Can anyone help me with a simple solution? I'm new to clickview.

I thank you in advance!

topic How to calculate an average based on the list box ? in QlikView

How to calculate an average based on the list box ?