Using set analysis on multiple condition for a single column

Iwin — Wed, 19 May 2021 18:06:11 GMT

Hi all,

I want to perform set analysis on multiple fields.

Eg for a single column Revenue ,it is calculated as follows :

if(class_Category='bill_to_Rev' and CLASS_CODE = 'BILL_EQUAL_TO_REV',sum(sales amount) else

sum({<class_Category='Sales'>}sales) -sum({<class_Category='Sales'>}costofgoods)/sum({<class_Category='Sales'>}sales) )

How can i put this in single set analysis expression?

topic Using set analysis on multiple condition for a single column in QlikView