Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
jmonroe918
Creator II
Creator II

NORMINV Function

Is there anyone who is familiar with the NORMINV (inverse of Normal Distribution calculation) as it relates to the same function (NORMSINV) in MS Excel? I am trying to calculate the process sigma of complaints vs shipments.

The formula using NORMSINV (Excel) as follows: =(1- NORMSINV(1-((Total Defects) / (Total Opportunities))) + 1.5.

The NORMSINV function is QlikView is: =(NORMINV, prob, mean, std dev).

I would rather not calculate this in Excel and then load the table into QlikView. I'd rather load the data table listing Sites, Years, Period, Complaints and Shipments and make the calculation in QlikView. That will prevent me from having to update the spreadsheet before reloading.

Thanks in advance for any help with this one.

Jeff

1 Reply
Not applicable

=NORMINV(1-Yield,0,1)-1.5

Where yield is your Defect per million expressed as a %