Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
avishaiz
Contributor III
Contributor III

Set analysis

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

1 Reply
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand