Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for
Did you mean:
Not applicable

## Help!! How to calculate Average? (Six-Sigma, PPK)

Hello,

I am trying to build a Xmr Chart with the data below. I always calculate the Average and the Moving Range Average with the selected data only

 ID_1 VALUE LSL USL MovingRange 1667331 16,6 8 20 - 1137512 12,931 8 20 3,669 1667326 11,1 8 20 1,831 1667325 11,1 8 20 0 1667324 16 8 20 4,9 1137513 11,0837 8 20 4,9163 1667323 18,5 8 20 7,4163 1137514 13,5468 8 20 4,9532 1137515 12,931 8 20 0,6158 1137516 13,5468 8 20 0,6158 1137517 14,1626 8 20 0,6158 1137518 16,0099 8 20 1,8473 1137519 9,8522 8 20 6,1577

My dimension is: =If((Filter=vF_0)And(vAllowCalc=1),ID_1),

expression is: =If((Filter=vF_0)And(vAllowCalc=1),VALUE1),

expression for MovingRange is: =If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)).

I cannot make expression for calculating average of the MovingRange expression

=If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)).

All my attempts were unsuccessful

Can anyone help me please?

Thank you very much.

(see attached file)

2 Replies
Not applicable
Author

Hi Ivan,

I'm also finding same kind of solution with small change like with aggr.

Do you got the solution if yes, please share to me.

Regards,

venkat

Partner - Champion III

Hi

This should do the trick:

=Avg(Aggr(If(((Filter=vF_0)And(vAllowCalc=1)),fabs(Above(VALUE1)-VALUE1)), ID_1))

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser