Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
COUNT( {$<NR_FATO={1,0}, NM_TIPO_CANCELAMENTO=> } DISTINCT CODIGO)
Hello
I´ve this expression above as variable.
I´m using it in a chart to group by city.
But i need to catch the max of this count.
Anyone can help me?
Thank you
You have at least 2 Options (im sure there are many more)
1. Define the Count expression in the script using "If" instead of set analysis (Lets call it CountDigo for example).
Then you can add a calculation for Max(CountDigo)
2. Use RangeMax Function
Thank you Ori,
Do you have example of this?
You may Send me your qvw file and ill show you.
My QVW have 130mb
Try this:
Max(Aggr(Count([Your Count Expression]),CODIGO))
See attachment