topic Chart Grid with Percent Totals in QlikView

Chart Grid with Percent Totals

Mon, 25 Jul 2016 13:44:17 GMT

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

Re: Chart Grid with Percent Totals

sunny_talwar — Mon, 25 Jul 2016 14:03:09 GMT

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

Re: Chart Grid with Percent Totals

Tue, 26 Jul 2016 12:21:13 GMT

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)

Re: Chart Grid with Percent Totals

sunny_talwar — Tue, 26 Jul 2016 15:50:01 GMT

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]))