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: 
Anonymous
Not applicable

Exclude numbers from and expression

I am creating a line chart and in one of my expressions (Orders)  I am trying to sum up the orders but when I did

=Sum(Orders)     I noticed that there is a spike in the numbers.  I am wanting to exclude all the numbers in Orders that caused the spike and not used them in this line.  So I tried to do something like this

=if(Orders <5000,sum(Orders))   but my line just went away then.

Is there anything I can do to sum up the orders but keep anything over 5000 out?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

1 Reply
swuehl
MVP
MVP

=sum(if(Orders <5000,Orders))


Conditional Aggregations