Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Avrage sum of sales of a category compared to a month of that category:
i want to creat a gauge where i get the sum of sales of a selected category
the minimum of the gauge need to be the average sum of the whole category sales (the whole data set) * 0.5
eg:
the category is jeans sum of sales
the minimum of the gauge is the average sum of sales for the jeanscategory for the year or some other length of time.
than
I'm guessing you want avg({<category=>} aggr(sum{<category=>}sales),category))/2 as minimum for the gauge.
If that's not correct then please post a small qlikview document that illustrates your question.