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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
anthony2
Contributor
Contributor

What is this called in Set Analysis?

 

What is it called in QlikView when you do the following highlighted in red ?  I am trying to find more examples but I don't know what search term to use.

count({$<Year=, Month=, YearMonth=,Customer={"=max({$<Sales={'>0'}, Year=, Month=, 
YearMonth=, OrderDate={'<=$(=max(OrderDate))'}>} OrderDate)< $(=max(OrderDate)-60) 
and max({$<Sales={'>0'}, Year=, Month=, 
YearMonth=, OrderDate={'<=$(=max(OrderDate))'}>} OrderDate)>= $(=max(OrderDate)-120)"}>} 
distinct Customer)

 

 

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

For a start, see the attachment.

View solution in original post

4 Replies
BrunPierre
Partner - Master II
Partner - Master II

anthony2
Contributor
Contributor
Author

Thanks but, that link only shows examples with simple set modifiers like Year={2020} or Country={'Sweden'}. The example in my post has a complex "selection" for Customer.  I'd like to learn more about it but I could not find examples in the official documentation.

BrunPierre
Partner - Master II
Partner - Master II

For a start, see the attachment.

anthony2
Contributor
Contributor
Author

Thanks! This is helpful.