Exclude numbers from and expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Exclude numbers from and expression

swuehl — Mon, 30 Jan 2017 20:05:07 GMT

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

Conditional Aggregations

topic Re: Exclude numbers from and expression in QlikView

Exclude numbers from and expression

Re: Exclude numbers from and expression