# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor III

## Sum if correction needed - HELP

Hi Guys

I'm new on QlikView and trying to learn basics nowadays.

If(Match([Current Sell and Renew Gate],'No Bid' , 'Lost' , 'Abandoned'), Sum ([Total Contract Value]= 'No Bid','Lost','Abandoned')

Labels (1)
• ### Sum if correction needed - HELP

5 Solutions

Accepted Solutions
MVP

Try this

Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value])

Contributor III
Author
It worked 🙂

Thanks Sunny bhai 🙂
MVP

But if you just do this

Sum ({<[Current Sell and Renew Gate] = {'Won','Gate 1','Gate 2','Gate 3','Gate 4'}>} [Total Contract Value])

would it not automatically exclude No Bid, Lost and Abandones because it will only choose the above 5?

MVP

Contributor III
Author
noted .. closing this one.
10 Replies
MVP

Try this

Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value])

Contributor III
Author
It worked 🙂

Thanks Sunny bhai 🙂
Contributor III
Author
One more correction needed if you don't mind .

I'm Trying to use if and minus two selections sum with each other.

Sum ({<[Current Sell and Renew Gate] = {'Won','Gate 1','Gate 2','Gate 3','Gate 4',-,'No Bid','Lost','Abandoned'}>} [Total Contract Value])

Thanks
MVP

Not sure I understand, can you elaborate with an example may be?

Contributor III
Author
I need to minus these two braces brackets in below command {xxxx}-{xxxx}

For Understanding ====>> Sum ({<[Current Sell and Renew Gate] = { xxxx} - {xxxx} }>} [Total Contract Value]) <<====

Below Command to correct
Sum ({<[Current Sell and Renew Gate] = ({'Won','Gate 1','Gate 2','Gate 3','Gate 4',} - {'No Bid','Lost','Abandoned'}>}) [Total Contract Value])
MVP

But if you just do this

Sum ({<[Current Sell and Renew Gate] = {'Won','Gate 1','Gate 2','Gate 3','Gate 4'}>} [Total Contract Value])

would it not automatically exclude No Bid, Lost and Abandones because it will only choose the above 5?

Contributor III
Author
ooh yes you are right .

Funny me 🙂

Thanks for the help ( GOD bless Keep Smiling )
Regards,
Abdullah
Contributor III
Author

Hi ,

Need Help.
Can I get [Total contract Value] result value below 2,000,000  only.

Review below command what I am doing wrong.
Sum ({<[Current Sell and Renew Gate] = {'No Bid', 'Lost', 'Abandoned'}>} [Total Contract Value] < '2000000')

Thanks

Abdullah

MVP