Expression with multiple conditions

EvanBarrick — Tue, 26 Mar 2019 20:51:26 GMT

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

Re: Expression with multiple conditions

Vegar — Tue, 26 Mar 2019 21:02:57 GMT

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/SetAnalysis/set-analysis-expressions.htm

topic Re: Expression with multiple conditions in App Development

Expression with multiple conditions

Re: Expression with multiple conditions