Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

delbooth
New Contributor II

Conditional sum

Hi.

I have just started using Qlik sense desktop.  i am trying to sum a column called quantity collected when the material type in a second column is Lead.

Also does anybody know of a good set of expression examples for visualizations

Any help, greatly appreciated,

Del

2 Replies
jwjackso
Contributor III

Re: Conditional sum

=Sum({<material={'Lead'}>}Quantity)

https://www.youtube.com/watch?v=YMQJnKMkfxg

zebhashmi
Valued Contributor

Re: Conditional sum

in table

Sum(if(material='Lead',1)

or

Sum(if(material='Lead',Qty)

Community Browser