Chart Grid with Percent Totals

[#1]

Hi looking for a bit of help in the Picture below the black chart is what I have created in Qlikview. Basically on a manufacturing process I'm recording the temperature every 10m against a layer. If the temperature is with in limits the dot is Green if it is out side the limits the dot is Red.

All I want to do is count the number of Green dots and show them as a percentage against both the layer and every 10m as shown in blue in the mock up below.

As you can see from the Straight Table view I already have a Pass / Fail Flag, just need to added these up and work out a percentage.

Any help would be much appricated.

Thanks

Mark

[sunny_talwar]

Is Pass/Fail a flag created in script or an expression? Would you be able to provide a sample to look?

[#3]

Hi Sunny

Thanks for coming back

My Pass / Fail Flag is based on the following equation below.

Basically if the average is between the Upper and Lower Control Limits it = 0, anything else is 1.

=if(avg($(vFieldAT))>= vR1TempLCL, if(avg($(vFieldAT))<= vR1TempUCL, 0, 1),1)

[sunny_talwar]

May be this for Percentage:

=If(Avg($(vFieldAT))>= vR1TempLCL, If(Avg($(vFieldAT))<= vR1TempUCL, 0, 1),1) /

Sum(TOTAL <[Layer]> Aggr(If(Avg($(vFieldAT))>= vR1TempLCL, If(Avg($(vFieldAT))<= vR1TempUCL, 0, 1),1), Layer, [10 Meters]))