Expression with multiple conditions

[EvanBarrick]

I am attempting to structure an expression to have the following conditions:

PRICE > '0'

BUYER_TYPE_CODE  <> 'ADULT'

BUYER_TYPE_CODE NOT LIKE 'MP*'

BUYER_TYPE_CODE  NOT LIKE 'STH*'

RETURN THE SUM OF QTY

I TRIED:

=SUM(IF(PRICE > '0' and BUYER_TYPE_CODE  <> 'ADULT' and BUYER_TYPE_CODE NOT LIKE 'MP*' and BUYER_TYPE_CODE  NOT LIKE 'STH*' , QTY))  but did not return the result I was expecting

[Vegar · Accepted solution]

I would recommend you to explore the possibilities off set analysis

Sum ({< PRICE = {">0"},
BUYER_TYPE_CODE -= {'ADULT',"MP*","STH*"}
>}QTY)

Read more here: https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAn...