# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results 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])

Employee

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

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.

Champion

try this one

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

Sunil Chauhan
Creator III

Try this..

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

Not applicable
Author