Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
BSCIknowlec
Contributor III
Contributor III

PPK set analysis calculation

hi experts! looking for some advice 🙂

im trying to get a bar chart that displays the ppk analysis per batch number. however im having some problem getting the agg function of my calculation so far.  i have the correct formula but not the correct variables

here is a snip of all my columns that im puling into my app.

BSCIknowlec_1-1616402483253.png

 

 

so i just need to display the ppk of total tests values that have the same batch number. my ppk formula is ="(RangeMin($(vPpU),$(vPpL)))"

PPL= "=($(vMean)-$(vLSL))/($(v3_Standard_Deviation))"

PPU= "=($(vUSL)-$(vMean))/($(v3_Standard_Deviation))"

 

i think my issue is with my mean and standard deviation formulas:

mean = "Avg(Aggr(Sum(PartParamValue),TOKEN83,Batch))"

STD="=3*(Stdev(Aggr(Sum(PartParamValue), TOKEN83, Batch)))"

Using the above calculation i get the following for 3 batch numbers:

BSCIknowlec_2-1616402617470.png

 

however the ppk for batch number 26127084 should actually be 2.43. the other numbers are incorrect as well.

i believe its a problem with my variables "TOKEN83" and "Batch". 

does anyone have any tips for me to get the correct variables in there so it gives me the correct ppk analysis per batch number?

 

thanks!

 

 

 

0 Replies