topic monthly AVG deviations in QlikView

monthly AVG deviations

ilanbaruch — Sat, 16 Nov 2024 01:00:46 GMT

Hi all,

In my model I have values for employee per month.

In a table with Employee, Month as dims I want to add two new expressions:

monthly average
monthly average deviations

i/e

employee	month	value	monthly AVG	deviations
A	Jan	45	48.7	92%
A	Feb	52	48.7	107%
A	Mar	38	48.7	78%
A	Apr	60	48.7	123%

Any ideas?

Re: monthly AVG deviations

Frank_Hartmann — Sat, 21 Mar 2020 11:02:08 GMT

script:

LOAD * INLINE [
employee , month, value
A, Jan, 45
A, Feb, 52
A, Mar, 38
A, Apr, 60
];

Straight Table:

dim1: employee

dim2: month

expr1: sum(value)

expr2: avg(TOTAL value)

expr3: sum(value)/ avg(TOTAL value)

Re: monthly AVG deviations

Brett_Bleess — Tue, 14 Apr 2020 19:26:15 GMT

If Frank's post got you what you needed, please be sure to close out your thread by using the Accept as Solution button on his post to do so. This will give him credit for the help and let other Members know it worked. If you did something different, you can post that and then mark it, and if you still need further assistance, please leave an update post.

One place you can use to help with these situations is the Design Blog area of the Community, there are 700 plus mostly how-to posts there that you will likely find helpful in giving you ideas on how to go about things.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett