Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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
Creator
Creator

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

 
Jacek
Creator
Creator

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
Creator
Creator

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

C'est bon j'ai trouvé 

 

Merci