11 Replies Latest reply: Nov 29, 2016 7:55 AM by Brendt Wooi RSS

    Average sales expression over selection

    Brendt Wooi

      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.