topic Re: Max Variable in QlikView

Max Variable

Wed, 04 Jan 2012 12:46:03 GMT

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 — Wed, 04 Jan 2012 12:54:39 GMT

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

Wed, 04 Jan 2012 12:56:43 GMT

Thank you Ori,

Do you have example of this?

orital81 — Wed, 04 Jan 2012 12:58:09 GMT

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

Wed, 04 Jan 2012 13:11:04 GMT

My QVW have 130mb

orital81 — Wed, 04 Jan 2012 13:17:11 GMT

Try this:

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

See attachment