Skip to main content

New to Qlik Sense

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

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
AbdullahJamil
Contributor III
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)
5 Solutions

Accepted Solutions
sunny_talwar

Try this

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

View solution in original post

AbdullahJamil
Contributor III
Contributor III
Author

It worked 🙂

Thanks Sunny bhai 🙂

View solution in original post

sunny_talwar

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?

View solution in original post

sunny_talwar

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

View solution in original post

AbdullahJamil
Contributor III
Contributor III
Author

noted .. closing this one.

View solution in original post

10 Replies
sunny_talwar

Try this

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

AbdullahJamil
Contributor III
Contributor III
Author

It worked 🙂

Thanks Sunny bhai 🙂
AbdullahJamil
Contributor III
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
sunny_talwar

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

AbdullahJamil
Contributor III
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])
sunny_talwar

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
Contributor III
Contributor III
Author

ooh yes you are right .

Funny me 🙂

Thanks for the help ( GOD bless Keep Smiling )
Regards,
Abdullah
AbdullahJamil
Contributor III
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

sunny_talwar

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