Sum If Function shows zero value

Massedamha — Sat, 16 Nov 2024 01:18:19 GMT

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

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

Re: Sum If Function shows zero value

tresB — Wed, 12 Feb 2020 09:20:59 GMT

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

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

Massedamha — Wed, 12 Feb 2020 09:43:41 GMT

Worked, Thanks Alot