Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I assume you are using the conditional outside the aggregation function, you should include it in the aggregation:
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.