Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum with 2 conditions

Hi qlik folks

I'm freaking out to make an formula to sum with two statements basically is like that

Sum(<{[Invoice Type] ={'SF','SFT'} {<[BU ={'710'}>} [NET SALES TOTAL]>)

or

Sum(<{([Invoice Type] - {'SDO'})} {<([BU ={'710'})>} [NET SALES TOTAL]>)]

Cheers!

8 Replies
Not applicable
Author

I've also have tried this one

Sum({$<[Invoice Type]-={‘SDO’}, [BU] = {720}>} [NET SALES TOTAL])

Anonymous
Not applicable
Author

Hello,

Try putting the 720 value in single quotes.

Example:
{'720'}

Not applicable
Author

HI Sean Tks for your resposnse

I did... but dont change at all

I have suceess only when I put the Invoice Type as List Box and the Business Unit into the formula

sum({$<[BU]={720}>} [NET SALES TOTAL])

Not applicable
Author

Hello Leo,

Try this:

Sum({$<[Invoice Type] = {'SDO'}, [BU]={'710'}>} [NET SALES TOTAL])

Hope it helps

Rgds

Ema

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expressions

Sum({<[Invoice Type] ={'SF','SFT'} , [BU ={'710'}>} [NET SALES TOTAL])

or

Sum({<[Invoice Type] -= {'SDO'}, [BU ={'710'}>} [NET SALES TOTAL])

Note: Qlikview will show errror near -= but it works.

Hope this helps you.

Regards,

Jagan.

SunilChauhan
Champion
Champion

try this one


Sum({$< [BU] = {720}>} [NET SALES TOTAL]) - Sum({$< [Invoice Type] = {'SDO'}>} [NET SALES TOTAL])

Sunil Chauhan
alkesh_sharma
Creator III
Creator III

Try this..


Sum({<[Invoice Type] ={'*'}- {'SDO'}, [BU ={'710'}>} [NET SALES TOTAL])

Not applicable
Author

This might helpful to u

Sum({$<[Invoice Type] = {'SDO'}, [BU]='710'>} [NET SALES TOTAL])