Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
davidoxi
Contributor III
Contributor III

calculated field sum

I want to sum the general total of calculation field :

table.png

6 Replies
sunny_talwar

This seems like a straight table, try to set total mode to sum on the expression tab for NB Commande_Stock expression

davidoxi
Contributor III
Contributor III
Author

I want to sum up

table.png

sunny_talwar

What are the expressions you are using? Would you be able to share a sample?

davidoxi
Contributor III
Contributor III
Author

Somme_LN_UrgentT /(Somme LN_Stock +Somme_LN_URGAENT )

sunny_talwar

Other two expressions?

davidoxi
Contributor III
Contributor III
Author

Somme LN_Urgent  = sum(Aggr(count(if(match([Type de commande], 'URGENT','GROS', 'PVI')>0, [N° ligne])),[N° donneur d'ordre])) ;

Somme LN_Stock = sum(Aggr(count(if(match([Type de commande],'STOCK','PROMO')>0, [N° ligne])),[N° donneur d'ordre]))