Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Max Variable

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

5 Replies
orital81
Contributor III

Re: Max Variable

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

Not applicable

Max Variable

Thank you Ori,

Do you have example of this?

orital81
Contributor III

Re: Max Variable

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

Not applicable

Max Variable

My QVW have 130mb

orital81
Contributor III

Re: Max Variable

Try this:

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

See attachment

Community Browser