Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
For a start, see the attachment.
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/SetAn...
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.
For a start, see the attachment.
Thanks! This is helpful.