# New to Qlik Sense

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

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

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

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

Labels (3)

• ### Can I get [Total contract Value] result value below 2

1 Solution

Accepted Solutions
MVP

I can't be certain without seeing some sample data and expected output from it, but may be this

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

11 Replies
Partner

Try this

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

You Know What To Do.
Contributor III
Author
Thanks for the reply.
no line appearing on chart with this command.
Partner

what it shows? can you share the screenshot?

Try the below command

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

You Know What To Do.
MVP

What is the chart dimension/s where you are using this expression?

Contributor III
Author

It's Combo chart with 1 dimension which are months and 3 expressions which are 2 Data Bars and 1 Data Line but Data line is not appearing .

Please find attached all 3 expressions Jpeg

MVP

Do you have less than, 2,000,000 for the last expression? Aggregating on the month level, may be each month have a value greater than 2,000,000 for your expression?

Contributor III
Author

Yes you are right.

In my mind I want to remove only those individual bids while monthly sum which are more than 2 millions individually.

Thanks for helping guys 🙂

Regards,

Abdullah

MVP

Sorry I am not sure I understand? Did you get what you wanted? or is there a question for us?

Contributor III
Author
Thanks for patience Sunny .

Still a question for you.
how to remove only those individual bids from [Total Contract Value] column while monthly sum which are more than 2 millions individually.

Need to correct below mentioned command
If(Sum ({<[Current Sell and Renew Gate] = {'Won','Gate 1','Gate 2','Gate 3'}>}
[Total Contract Value] )<2000000,Sum ({<[Current Sell and Renew Gate]
= {'Won','Gate 1','Gate 2','Gate 3'}>} [Total Contract Value] ),'NIL')