how to average of 3 products wrt each other.

[#1]

Product	Values
FO	23
RX	766
TT	1233

I have a requirement where I need to show average values for FO, RX, TT with respect to each other in an qlikview expression.

don't know if we can create it with the help of set analysis or aggr function.

Like my total is 2022 so FO would be 23/2022=.011% likewise.

could you please help here.

[Anil_Babu_Samineni]

May be by using this expression

Dim as Product

Expressions are

1) Sum(Values)

2) Sum(Values)/Sum(TOTAL Values)

And then goto Number Tab then use this for fixed to 3 decimals (#,##0.000)

[khalander]

Hi,

Use this

=avg(Aggr(Values,Product)) or you can use simply avg(Values)

[qlikviewwizard]

Hi Try like this:

[rahulpawarb · Accepted solution]

Hello Harpreet,

Trust you are doing good!

To average values for each product please use Sum(Value)/Sum(TOTAL Value) expression and further modify it using Num() function as per your need.

I hope this will be helpful.

Thank you!

Rahul