Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count number of Orders above $25

I want the ability to count orders that are less than $25, how can I get qlikview to do that?

1 Reply
whiteline
Master II
Master II

Hi.

There is a feature that called 'set analysis' (look at help, there are some useful examples).

=count({<OrderID={"=Sum(Amount)<25"} distinct OrderID)