topic Re: Joining two different formulas in same expression in QlikView

Joining two different formulas in same expression

Tue, 03 Mar 2015 16:37:36 GMT

I am trying to join two different sets of formulas which work individually into one single measure(expression)

eg: expr1: Sum({<column1 ={'value1','value2'}>}Toal_Sales)

expr2: Sum({<column2 ={'value3','value4'}>}Sales_Amount)

I tried adding + and AND in between : Sum({<column1 ={'value1','value2'}>}Toal_Sales) + Sum({<column2 ={'value3','value4'}>}Sales_Amount) but this does not seem to help.

Thank you.

Re: Joining two different formulas in same expression

JonnyPoole — Tue, 03 Mar 2015 16:50:25 GMT

Is this the logic you are after ?

sum ( if ( (column1=value1 or column1=value2) , Toal_Sales,0) + if(column2=value3 or column3=value4, Sales_Amount,0 ) )

Re: Joining two different formulas in same expression

Tue, 03 Mar 2015 21:20:58 GMT

Sorry but when I looked at my values closely , it is not considering the values under second if statement

Re: Joining two different formulas in same expression

JonnyPoole — Tue, 03 Mar 2015 21:32:10 GMT

can you post your sample QVW ?

I did a quick test with some sample data below and your original approach doesn't look incorrect

Re: Joining two different formulas in same expression

Tue, 03 Mar 2015 21:56:58 GMT

Yes you are right, it did work for me this time. Thanks again!!!