topic Chart Table Calculation in QlikView

Chart Table Calculation

Tue, 18 Jan 2011 13:07:00 GMT

Im having difficulty with a calculation or 2 in a table chart.

the green items i can get no problem, those are my fields that i have available. the orange fields i cant get right, i must get the total of a column but for a specific TestNumber only...

So for AvgTest i want the total of AvgSample divided by 10(Sample) BUT ONLY FOR THE SPECIFIC TESTNUMBER.

Same with DiameterAvg. I want the total of Diameter divided by 10 (Sample) but only for the specific testnumber.

The sheet below is what it should look like if the calculations work. Any help? Im exhaust trying to figure out how to use a criteria of TOTAL TestNumber only..

Chart Table Calculation

lironbaram — Tue, 18 Jan 2011 13:44:11 GMT

hei

attach is an example of what you asked for

it uses the total in the avg fields

hope its helps you

Chart Table Calculation

jonathandienst — Tue, 18 Jan 2011 13:57:08 GMT

Ruan

Perhaps this:

Avg(TOTAL <TestNumber> Sample)/10

Jonathan

Chart Table Calculation

amars — Tue, 18 Jan 2011 15:18:30 GMT

Hi Ruan,

Couldn't understand ur problem. But search for RangeAvg() , ur solution lies in that.

Chart Table Calculation

Tue, 18 Jan 2011 16:18:31 GMT

Here is another explanation.

TestNumber, Sample, One, Two & Diameter is data from our quality control SQL.

They do a TEST which consist of 10 samples each. for each sample 2 different values is taken in.

So this i done in excel quickly, COLUMN E must display the average of reading ONE & TWO which is easy. My problem is with COLUMN F & H.

It must SUM all the values from COLUMN E for each seperate test number then divide it by die Sample amount (10 on most days, but i use max to not hardcode it).

So in effect i will have 10 of the same values linked to a different sample number.

Chart Table Calculation

Wed, 19 Jan 2011 11:06:57 GMT

just tried this now, this is EXACTLY what i wanted.

so the <TestNumber> part specifies that the TOTAL must only be applicable to within TestNumber field correct?

Chart Table Calculation

jonathandienst — Wed, 19 Jan 2011 14:11:57 GMT

Ruan

so the <TestNumber> part specifies that the TOTAL must only be applicable to within TestNumber field correct?

Correct

Jonathan

Please approve the post so that others can see the preferred solution.

Yet another Qlikview Blog