5 Replies Latest reply: Mar 9, 2017 10:26 AM by Andrew Jenkins RSS

    Avg Counts from a table

    Andrew Jenkins

      Hi

       

      I'm new to Qlik in particular Qlik Sense so apologies if this is a very basic question.

       

      What I want is an avg of the last 7 days sales.

       

      I have a table which has the following data:

       

      DateSales
      2017-03-013130
      2017-03-023131
      2017-03-033131
      2017-03-043130
      2017-03-053130
      2017-03-063130
      2017-03-073133
      AVG3131

       

       

      The expression for the dates is simply:

       

      [SaleDate]

       

      The expression to calculate the sales is simply:

       

      count([%SaleID])

       

      In the table I've manually filtered the dates to the last 7 days.

       

      The AVG in the above table is the figure that I want out to be able to calculate in a KPI, however I cant seem to get it to work.

       

      If anyone can help, I would be really grateful.

       

      Andrew