Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fatihtomruk
Contributor III
Contributor III

Sum values except some range

Hi,

I want to sum values as below except for the numbers begins with '7'.

Cound you please help?

thank you.

 

NumbersAmount
100200
250600
700100
78050
782750
2 Replies
sunny_talwar

May be like this:

Sum({<Numbers -= {'7*'}>} Amount)

dsharmaqv
Creator III
Creator III

Try

Sum({<Numbers -= {'7*'}>} Amount)