topic Re: Partial average. in QlikView

Partial average.

Wed, 05 Nov 2014 02:59:01 GMT

Hello all, I am lee.

I want to have partial average instead of partial sums in example format.

I attached example.

please let me know.

Thank you so much

Re: Partial average.

Wed, 05 Nov 2014 03:14:06 GMT

Im lee

Example here

Re: Partial average.

SunilChauhan — Wed, 05 Nov 2014 03:27:53 GMT

use expression as

sum(TAT)/Count(distinct TAT)

sum(TAT)/Count(TAT)

hope this helps

Re: Partial average.

JonnyPoole — Wed, 05 Nov 2014 03:28:29 GMT

I divided by the number of FABOUT_TM (top screenshot) and combination of FABOUT_TM and STAT_AREA (below screenshot)

Above: sum(TAT)/ count( DISTINCT FABOUT_TM) ...partial row averages and column totals

Below: sum(TAT)/ count( DISTINCT FABOUT_TM&STAT_AREA) ...partial row averages and column averages

Re: Partial average.

Wed, 05 Nov 2014 03:33:36 GMT

could you give me . example qvw. file please~

Re: Re: Partial average.

JonnyPoole — Wed, 05 Nov 2014 03:35:18 GMT

here is the qvw

Re: Re: Partial average.

SunilChauhan — Wed, 05 Nov 2014 04:09:31 GMT

see the modified qvw attached by you

Re: Partial average.

Wed, 05 Nov 2014 04:55:53 GMT

Thank you Poole~

but how FABOUT_TM is same and different LOT?

isn't it Wrong using DISTINCT function?

Re: Partial average.

sujeetsingh — Wed, 05 Nov 2014 05:00:46 GMT

There are two things:

Straight table provide options to define a expression for total

Pivot table do not provide such option hence if you are having average in your expression the pivot total will use the same expression to calculate the totals.

Re: Partial average.

SunilChauhan — Wed, 05 Nov 2014 06:09:23 GMT

distinct will take single ocuurance of partiuar

where as if you want to count all

use Count(FABOUT_TM )

Re: Partial average.

Wed, 05 Nov 2014 06:48:37 GMT

as you can see,

Count(FABOUT_TM) make data different.

Sorry to bother you.~

Re: Partial average.

SunilChauhan — Wed, 05 Nov 2014 06:57:02 GMT

as per you qvw ,i can see on count distinct gives correct result

sum(TAT)/Count(distinct FABOUT_TM)

for example

11.59	0.18	1.76	17.93	6.33	12.16
0.70	0.10	1.99	16.45	3.51	1.03
0.65	0.13	1.87	18.94	6.24	1.05
0.63	0.16	3.48	17.84	2.17	1.04
0.44	-	0.78	21.31	1.04	0.04
0.41	-	1.17	33.59	1.83	0.04
0.43	-	0.78	9.35	0.19	0.12
0.50	0.10	1.08	14.69	2.13	1.24
0.45	0.11	1.02	11.31	2.00	0.92
0.39	0.07	1.02	11.41	1.61	0.93
0.58	0.09	1.03	10.68	1.67	0.97
1.52	0.12	1.45	16.68	2.61	1.78

calculate below averages it will show you correct figure

as i can see distinct value for LOT against devices

hope this helps

Re: Partial average.

Wed, 05 Nov 2014 08:17:33 GMT

um... i'll study cont.

anyway Thanks chauhans85~