topic aggr() how to use it in QlikView

aggr() how to use it

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

Hello,

I have this table :

ID_EMP	Emploi	PRODUIT_ID	DUREE	PRODUITS_	REALISATION_NBR	REALISATION_VOLUME	COEF_NB	COEF_VOL	SCORE_NB	SCORE_VOL
0101	EMPLOI01	x1	8	P1 SUP8	1,0	11500,0	30	30	30	345,0
		x2	8	P1 SUP8	1,0	700,0	15	0	15	0,0
		x3	8	P1 SUP8	1,0	10200,0	30	30	30	306,0
		x4	8	P1 SUP8	1,0	0,0	15	0	15	0,0
		x4	8	P1 SUP8	1,0	100,0	15	0	15	0,0
		x5	8	P1 SUP8	1,0	10000,0	15	10	15	100,0
		x6	4	P1 INF8	1,0	10000,0	15	10	15	100,0
					-	-	-	-	-	-

PRODUITS_ is calculated using DUREE,

REALISATION_NBR is sum(VALUE) when PRODUIT_REF='100'

REALISATION_VOL is sum(VALUE) when PRODUIT_REF='200'

COEF_NB is calculated using PRODUITS_ and REALISATION_VOL

COEF_VOL is calculated using PRODUITS_ and REALISATION_VOL ( same as the previous one but with other coef )

SCORE_NB is calculated using COEF_NB x REALISATION_NBR

SCORE_VOL is calculated using COEF_VOL x REALISATION_VOL

My question, why my total is not calculated even when I checked in the window='PRESENTATION' the ID_EMP.

How to use the Aggr() if it is the solution here.

Regards

Re: aggr() how to use it

swuehl — Thu, 27 Sep 2018 15:36:19 GMT

I assume you are using the conditional outside the aggregation function, you should include it in the aggregation:

Use Aggregation Functions!

Re: aggr() how to use it

rubenmarin — Thu, 27 Sep 2018 15:40:04 GMT

Hi Amine, I'm not sure you'll need aggr(), maybe for some expression but not for all, here is a video that explains aggr()

Qlik Sense in 60 - The Aggr() function - YouTube

To get a solution answer is better is you upload a sample, so we can play with it and return with the expected result for the sample data.

Or at least you'll need to tell with expressions are you using and how are the total configured.

Note that if you are just using a field, without any aggregation function (Sum, Avg...), when QV has many different it returns Null(), because it doesn't know what operations has to do with all that different values.