topic How to insert a Max & Average in a chart in QlikView

How to insert a Max & Average in a chart

Thu, 13 Jun 2013 10:03:09 GMT

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

Re: How to insert a Max & Average in a chart

Thu, 13 Jun 2013 13:44:03 GMT

You could try something like this for the average:

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

Best,

Matt

Re: How to insert a Max & Average in a chart

Thu, 13 Jun 2013 13:57:42 GMT

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 ?

Re: How to insert a Max & Average in a chart

Thu, 13 Jun 2013 23:29:29 GMT

Hi,

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

See attached picture.

Re: How to insert a Max & Average in a chart

Fri, 14 Jun 2013 08:16:24 GMT

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)

Re: How to insert a Max & Average in a chart

Fri, 14 Jun 2013 08:39:09 GMT

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

Re: How to insert a Max & Average in a chart

Fri, 14 Jun 2013 09:01:12 GMT

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)

Re: How to insert a Max & Average in a chart

prodanov — Fri, 14 Jun 2013 10:22:54 GMT

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

Re: How to insert a Max & Average in a chart

Mon, 17 Jun 2013 16:02:11 GMT

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

Re: How to insert a Max & Average in a chart

prodanov — Mon, 17 Jun 2013 16:09:20 GMT

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

Re: How to insert a Max & Average in a chart

Mon, 17 Jun 2013 16:13:19 GMT

oh.. and how I could do that?

Re: How to insert a Max & Average in a chart

prodanov — Mon, 17 Jun 2013 16:56:39 GMT

See this application. Trigger is in Document Properties / Trigger - Field Event triggers