How to insert a Max & Average in a chart

[#1]

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

[#2]

You could try something like this for the average:

avg(aggr(sum(product),week))

Best,

Matt

[#3]

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 ?

[#4]

Hi,

Since you have two dimensions, instead of adding another expression you can enable an Average trend.

See attached picture.

[#5]

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)

[#6]

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

[#7]

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)

[prodanov · Accepted solution]

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

[#9]

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...

[prodanov]

You must create a trigger to select product AVG when user selected more than one product.