Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jenmclean
New Contributor II

Exclusions

What is the best way to write the following:

Sum(If(INV|DetTypeID = '4' and Match(KEY|ProductNumber = 'WARRANTY'),INV|InvoiceAmount)) as GR|Labor, //Labor

If DetailType = 4 then exclude product  number "warranty", include invoice amount and save as gross labor.

Thanks in advance!

1 Solution

Accepted Solutions

Re: Exclusions

Sum(If(INV|DetTypeID = '4' and not Match(KEY|ProductNumber = 'WARRANTY'),INV|InvoiceAmount)) as GR|Labor,


or


Sum(If(INV|DetTypeID = '4' and KEY|ProductNumber <> 'WARRANTY',INV|InvoiceAmount)) as GR|Labor,


talk is cheap, supply exceeds demand
1 Reply

Re: Exclusions

Sum(If(INV|DetTypeID = '4' and not Match(KEY|ProductNumber = 'WARRANTY'),INV|InvoiceAmount)) as GR|Labor,


or


Sum(If(INV|DetTypeID = '4' and KEY|ProductNumber <> 'WARRANTY',INV|InvoiceAmount)) as GR|Labor,


talk is cheap, supply exceeds demand
Community Browser