Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Using set analysis on multiple condition for a single column

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?

Labels (3)
0 Replies