I have a Title Expression that changes based on selection of field EVENT_NUMBER. If no selections, then title includes 'ALL' in text displayed, otherwise it displays 'TOP' with a selected count. This is fine as long as the first through n EVENTS are selected. Below is the expression to accomplish this.
Thanks for this Expression, it works perfectly! That being said, not so sure I understand the syntax and how it actually works ...not sure what the curly backets functionality is? I greatly appreciate you help.
is set analysis syntax. It says 'ignore selection in EVENT_NUMBER when calculating the aggregation I am embedded in' (i.e. the sum(EVENT_COUNT) ).
You need to ignore the selection, otherwise the rank will always be determined on the selected subset of EVENT_NUMBER (while you need the global rank, not affected by selection, right?).
The max( aggr( rank(...), EVENT_NUMBER)) is then just calculating the max rank out of your selected EVENT_NUMBER (here, it is important to only look at the selected items, so no set analysis part required here.
Very much appreciated! As I've not had any formal set analysis training I have had to pick this stuff up as I go. Your explanation helps tremendously. Glad there are so many folks such as yourself who have been quick to answer questions as they arise.
I've learned more about QV from the QV Community than any other source.