topic Re: Probleme Calcul Total TCD in QlikView

Probleme Calcul Total TCD

Mahmoud — Wed, 25 Nov 2020 17:20:09 GMT

Hello, I want to add the total column, I added it by "presentation" -> "show partial sums", but it does not calculate the total

the expression

Re: Probleme Calcul Total TCD

Kushal_Chawda — Wed, 25 Nov 2020 22:57:57 GMT

@Mahmoud try changing pivot table expression as below

= sum(aggr(YourExpression, Dimension1,Dimension2,Dimension3))

Re: Probleme Calcul Total TCD

Mahmoud — Thu, 26 Nov 2020 10:15:56 GMT

Thnak you @Kushal_Chawda ,

when i make it in dimension i have this error

and when i make it in expression, i have this

my expression:

=If(
((Sum({<Mouvement_ID={'Ventes'}>} Quantité) = 0)
and
(Sum({<Mouvement_ID={'Achats'}, Année=>} Quantité) > 0))
,
Sum(aggr(sum({<Mouvement_ID={'Achats'},Année=, Mois=, Groupe=>} Prix), Article, Groupe))
)

Re: Probleme Calcul Total TCD

Kushal_Chawda — Thu, 26 Nov 2020 10:27:50 GMT

@Mahmoud can you share sample file to look at?

Re: Probleme Calcul Total TCD

Mahmoud — Thu, 26 Nov 2020 10:44:46 GMT

Excuse me but i'm not allowed to do that, i'm not an administrator

Re: Probleme Calcul Total TCD

Mahmoud — Thu, 26 Nov 2020 14:47:41 GMT

@Kushal_Chawda Thank you, I found the solution thanks to you:

the expression in dimension:

aggr(sum({<Mouvement_ID={'Achats'},Année=, Mois=, Groupe=>} Prix), Article)