Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try Sum(If instead of If(Sum(, like:
Sum(if(Sales Type='Invoiced',[QTY],0))
Try Sum(If instead of If(Sum(, like:
Sum(if(Sales Type='Invoiced',[QTY],0))
Worked, Thanks Alot