Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.

Please guide on below command.

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

Please open a new thread for a new requirement. and close this thread 🙂

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

Please open a new thread for a new requirement. and close this thread 🙂