Sum if correction needed - HELP

[AbdullahJamil]

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')

[sunny_talwar · Accepted solution]

Try this

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

[AbdullahJamil · Accepted solution]

It worked 🙂

Thanks Sunny bhai 🙂

[AbdullahJamil]

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

[sunny_talwar]

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

[AbdullahJamil]

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])

[sunny_talwar · Accepted solution]

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?

[AbdullahJamil]

ooh yes you are right .

Funny me 🙂

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

[AbdullahJamil]

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

[sunny_talwar · Accepted solution]

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