Average without a Max and min value in Aggregation

[Anonymous]

Hi all

I have this:

Producto	PRECIO	TIENDA
1	10	1
1	31	1
1	4	1
1	2	1
2	4	1
2	7	1
2	5	1
2	10	1
1	5	2
1	10	2
1	15	2
2	10	2
2	20	2
2	20	2
2	30	2

I would like to have the average for each "TIENDA" and "PRODUCTO" without the max and the min value for each agregation.

TIENDA 1:     PRODUCTO 1     AVERAGE 17.5

TIENDA 1:     PRODUCTO 2     AVERAGE 6

TIENDA 2:     PRODUCTO 1     AVERAGE 10

TIENDA 2:     PRODUCTO 2     AVERAGE 20

I'm going to use in a expression of a simple table chart using TIENDA as dimension

I need Helpppppppppppp .... I'll pay you a beer ..... or two

Regards

M

[Anil_Babu_Samineni]

Can you look this?

Sum(Aggr(Avg({<PRECIO -= {'$(=Max(PRECIO))', '$(=Min(PRECIO))'}>} PRECIO), Producto, TIENDA))

[Anonymous]

Hi Anil

Thanks for answer

We tried do it but it quits the max of all the PRECIO and the min of alL the PRECIO, don't subset the data in PRODUCTO ... I don't know if I'm explaining very good so .. later I'll send u a small QV to see what happens ... ok?

[Anonymous]

Hi

Do you know how to attach documents??

It's looks imposible

Regards

M

[Anonymous]

Hi Anil

Thaks a lot in advance

Here the real situation, I give u a small example in Qv and a small Excel to make the checking

Thank you very very very much ....

[Anonymous]

HI Anil .. can u help me with this problem:::

Regards

M

[Anil_Babu_Samineni]

Still i am confusing, Why 17.5 Comes up instead of 7? Can you explain me the reason how you get for this filter

[Anonymous]

HI Anil, thank you for answering, I have a mistake with the average, the correct value is 7 .... sorry

Thanks a lot, I put attached an small example to work with

M

[Anil_Babu_Samineni]

In excel you are showing 7872, But in text object of Qlikview you want it as 8290. Can i know the Difference

For 7872, You need to write this?

Sum( Aggr(Avg(LM_PRECIO), LM_PRODUCTO_ID, LM_ENSENA_TEXT))

Or Remove the LM_PRODUCTO_ID from Table and then replace to expression