topic Re: Count of Rows with Aggr Count ? in QlikView

Count of Rows with Aggr Count ?

itatspectrum — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have the following requirement. I have 1.3 million test records and I'm trying to get to a right first time percentage. Below I have the sample data. This will value will be going in a text box initially, but will also be used as an expression against the Station as well to see a % Right first time against each test station.

SerialNo	Station	Passed	TestNum
001	Pack1	N	9001
001	Pack1	N	9002
001	Pack1	Y	9003
002	Pack1	Y	9004
003	Pack1	Y	9005
004	Pack2	Y	9006
005	Pack2	N	9007
005	Pack2	Y	9008

Serial No 1 & 5 failed the first test, and needed to be retested

Right First Count	3
Total Items	5
Right First Time %	60%

Not sure what is the right tool for the job?

Re: Count of Rows with Aggr Count ?

Anil_Babu_Samineni — Thu, 08 Dec 2016 23:57:50 GMT

I am not sure, What is your question?

Not sure what is the right tool for the job?

What does mean this?

Re: Count of Rows with Aggr Count ?

itatspectrum — Fri, 09 Dec 2016 00:53:44 GMT

Hi Anil, by tools i really mean function. for example is it an aggr function, or an internal resident load, or a count if etc.

Steve

Re: Count of Rows with Aggr Count ?

trdandamudi — Fri, 09 Dec 2016 02:29:50 GMT

Please see attached and hope this helps...