Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
AbdullahJamil
Contributor III
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

11 Replies
sunny_talwar

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

View solution in original post

AbdullahJamil
Contributor III
Contributor III
Author

It worked. Finally I got smiling data line in Combo chart.

Thanks you very much SUNNY 🙂