Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

calculation and median and mean

Hiya

i have this calculation

=Alt(Sum(Orders) - Above(Sum(Orders)), 0)


this gives me the difference in number for each week orders.


e.g


week 1  = 0,


week 2 = 15


week 3 = 5


i then want to add a sum to this to work out the mean and median of these figures.


e.g using additionally .... mean(Orders)


please help

1 Solution

Accepted Solutions
MVP
MVP

Re: calculation and median and mean

Maybe you can do it like discussed here:

Average of Delta's

2 Replies
MVP
MVP

Re: calculation and median and mean

Maybe you can do it like discussed here:

Average of Delta's

joeybird
Contributor II

Re: calculation and median and mean

Hiya

thank you

Kind Regards