Conditional sum

[delbooth]

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

[jwjackso]

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

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

[zebhashmi]

in table

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

or

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