Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a qlik view application that shows the total orders ordered per day (or week, month, etc).
My customer want to have an gauge 'Orders this week vs Average orders per week'. I am wondering or some knows how I can determine the average amount of orders per week?
Does someone have an idea?
Together with my collague I have found a solution that can also be useful for you:
Average per week = Num((Sum(OrderCounter) / Count(Distinct WeekYear)), '#####.')
Together with 'set analysis' that fix to the last week you can get the orders this week vs average orders per week.