Announcements
cancel
Showing results for
Did you mean:
Creator II

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

1 Solution

Accepted Solutions

Try this?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
6 Replies

How is your table looks like?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator II
Author

Hi Anil,

I have change the question now...

Thanks.

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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Creator II
Author

Hi,

Thanks,

I need to take particular months average. There are total 7 months, and i need to take average for 3 or 4 months and has to be dynamic not static. for eg. we are in Nov month and need average for past 3 month (aug, sep, oct) and if we are in dec then we need average for (sep, oct, nov)...