topic Re: What is this called in Set Analysis? in QlikView

What is this called in Set Analysis?

anthony2 — Mon, 10 Apr 2023 18:59:42 GMT

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)

Re: What is this called in Set Analysis?

BrunPierre — Mon, 10 Apr 2023 19:48:47 GMT

They are part of the Modifiers.

Here's more on set analysis: https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Re: What is this called in Set Analysis?

anthony2 — Mon, 10 Apr 2023 20:12:53 GMT

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.

Re: What is this called in Set Analysis?

BrunPierre — Tue, 11 Apr 2023 13:18:47 GMT

For a start, see the attachment.

Re: What is this called in Set Analysis?

anthony2 — Tue, 11 Apr 2023 14:53:13 GMT

Thanks! This is helpful.