Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead 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

VALUELSLUSLMovingRange
166733116,6820-
113751212,9318203,669
166732611,18201,831
166732511,18200
1667324168204,9
113751311,08378204,9163
166732318,58207,4163
113751413,54688204,9532
113751512,9318200,6158
113751613,54688200,6158
113751714,16268200,6158
113751816,00998201,8473
11375199,85228206,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.

Thanks in advance.

Regards,

venkat

jonathandienst
Partner - Champion III
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