Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
DAMIEN1
Contributor II
Contributor II

Expression retourne 0

Mon expression retourne 0 quelqu'un pourrait m'aider ?

 

=rangesum(aggr((rangesum(sum([Oct. 2018]),sum([Nov. 2018]),sum([Dec. 2018]),sum([Aou. 2018]) ,sum([Sep. 2018])) /
(rangesum( sum([poids.Poids_oct]),sum([poids.Poids_Nov]),sum([poids.Poids_Dec]),sum(poids.Poids_Aot),sum(poids.Poids_sept)))
*poids.Poids_Dec)*[Poids Arras],LIEN_VENTES))*CurseurMarché

 

6 Replies
Jacek
Educator-Ambassador
Educator-Ambassador

Do you have any sample data / screen?
DAMIEN1
Contributor II
Contributor II
Author

 
Jacek
Educator-Ambassador
Educator-Ambassador

make sure that this expression never return 0:

rangesum( sum([poids.Poids_oct]),sum([poids.Poids_Nov]),sum([poids.Poids_Dec]),sum(poids.Poids_Aot),sum(poids.Poids_sept)
)
DAMIEN1
Contributor II
Contributor II
Author

LA formule retourne bien la bonne valeur 

This expression return is ok 

Jacek
Educator-Ambassador
Educator-Ambassador

you can try add to aggr function nodistinct parameter
DAMIEN1
Contributor II
Contributor II
Author

C'est bon j'ai trouvé 

 

Merci