Max Variable

[#1]

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

[orital81]

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

[#3]

Thank you Ori,

Do you have example of this?

[orital81]

You may Send me your qvw file and ill show you.

[#5]

My QVW have 130mb

[orital81]

Try this:

Max(Aggr(Count([Your Count Expression]),CODIGO))

See attachment