Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have that kind of charts with a products' sales before and after one event (event = week 0) (one curved line = one product)
Is there any possibility to insert in that same chart the max or/and the avertage of that products for the selected weeks?
thank u very much for your help
I have an idea. You must create a inefficient dimension's value AVG, MAX and then expression will be like this:
=PICK(WildMatch(product,'AVG','*'),avg(total<month> amount),SUM(amount))
See in attached files
You could try something like this for the average:
avg(aggr(sum(product),week))
Best,
Matt
Hello thank u for answer but I automaticly get this
And I want to see all products from the other picture + the average curve. Is that possible ?
Hi,
Since you have two dimensions, instead of adding another expression you can enable an Average trend.
See attached picture.
Hello,
I tried that but in that case I have one straight line by product which is the average for that product for that period (see image attached) What I want is all selected products' average in one curve (and not line)
Hi
Would a Trellis be an option for you?
As you can see here I had a similar issue where your product could be my date and your weeks could be minutes
Gio
Hello,
I think that is not the same thing. In your chart u display just the min, average and max and not for example in your case the evolution for more days (one curve per day + one curve average )
That is what I have
And that is what I want to have
The black curve is the average ( I drawed it manually over the picture to show u what I am looking for)
I have an idea. You must create a inefficient dimension's value AVG, MAX and then expression will be like this:
=PICK(WildMatch(product,'AVG','*'),avg(total<month> amount),SUM(amount))
See in attached files
Thank u this is exactly what I am looking for
I have a little problem
In the table I want put my AVG I have only IDProduct and not a name product. The name product is in another table
so when I apply your solution on my qlikview and I have a product name selected it doesn't work ... I am trying to find a solution...
You must create a trigger to select product AVG when user selected more than one product.