Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

davidoxi
New Contributor III

calculated field sum

I want to sum the general total of calculation field :

table.png

6 Replies

Re: calculated field sum

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

davidoxi
New Contributor III

Re: calculated field sum

I want to sum up

table.png

Re: calculated field sum

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

davidoxi
New Contributor III

Re: calculated field sum

Somme_LN_UrgentT /(Somme LN_Stock +Somme_LN_URGAENT )

Re: calculated field sum

Other two expressions?

davidoxi
New Contributor III

Re: calculated field sum

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]))

Community Browser