3 Replies Latest reply: Nov 9, 2018 5:13 AM by Anil Samineni

# Average of Months Value

Hi Experts,

I need help in calculating average of months value, i have a column which has value and other is month.

Here if we take example for Shoe average comes to 3754121, how can i get this figure by using some expression in Qlik Sense.

 Item Value Month Shoe 2417957 1 Shoe 5676437 2 Shoe 484326 3 Shoe 7574809 4 Shoe 2617074 5 Shirt 2106173 1 Shirt 3720818 2 Shirt 4341418 3 Shirt 3403192 4 Shirt 1880157 5 Shirt 2417957 6 Trouser 5676437 1 Trouser 484326 2 Trouser 7574809 3 Trouser 2617074 4 Trouser 2106173 5 Trouser 3720818 6 Trouser 4341418 7 Cap 3403192 1 Cap 1880157 2

Thanks,

MAK.

• ###### Re: Grouping Clause for Multiple Tables

How is your table looks like?

• ###### Re: Average of Months Value

Hi Anil,

I have change the question now...

Thanks.

• ###### Re: Average of Months Value

You can simplify this in straight table

Num(Avg(Value),'#,##0')

If this is in Text box

=Num(Avg({<Item={'Shoe'}>} Value),'#,##0')

Or Script

Load Item, Num(Avg(Value),'#,##0') as Value Resident Table Group By Item;