Average sales expression over selection

[#1]

Good day.

i am hoping that somebody could help me, i am very new to Qlikview and have only just started using it.

we have setup a straight table with sales and budget information/columns. one of the requirements is to have a column with the average sales for the current year when the year is selected. but they would also like to average to change as they change the selections (eg. Month or day selected)

the expression i'm currently using is Sum or current year sales divided by 12. is that the correct expression? but im not sure how this would work when month or day is selected.

any help with this would be greatly appreciated.

[rido1421]

Hi Brendt

Remember to mark as correct if you have been assisted so that it can be closed 🙂

[#3]

Hi Ridhaa.

Thank you so much. i have marked it.

Thank you so much to everyone who has helped me with this, i really do appreciate it.

hopefully i will become a Qlikview master like all you fantastic people on the forum one day.