Sum If Function shows zero value

[Massedamha]

Hello All,

I am new to using Qlik 

i have been struggling to find the correct way to make a measure with a sumif or if equation

for an example the follwoing data

Sales Type	Customer	Date	Qty	Value	Costing
Invoiced	A	1.02.2019	1000	20000	12000
Invoiced	A	1.02.2019	1000	20000	12000
Invoiced	A	1.02.2019	1000	20000	12000
FOC	A	1.02.2019	1000	20000	12000
FOC	B	1.02.2019	100	0	1200
FOC	B	1.02.2019	100	0	1200
Invoiced	B	1.02.2019	1000	20000	12000
FOC	B	1.02.2019	100	0	1200

i tried the if equation as follows  in order to Calculate only the invoiced amount  and make it as a measure 

if(Sales Type='Invoiced',sum([QTY]),0)

the problem seems with the selection part.

would appretiate the help and thanks

[tresesco · Accepted solution]

Try Sum(If instead of If(Sum(, like:

Sum(if(Sales Type='Invoiced',[QTY],0))

[Massedamha]

Worked, Thanks Alot