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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)