max of aggr ignoring filter

[mohamed_ahid]

HI

in the sample below i'm trying to have the max of sum(value ) of all clients  .until now everything is ok .

But once i choose a client the max change depending on my choice .

how can i make my max(aggr()) function ignore the selection ?

[jerem1234 · Accepted solution]

Try:

=max({1}total

    aggr(

         sum({1<week= {">=$(=1)<=$(=9)"}> } value),

          [client]

         ) )

Hope this helps!

[MK_QSL]

Max({1}Total Aggr(SUM({1<week = {">=1<=9"}>}value),client))

[maxgro]

maybe adding a client=

max(total {<week= {">=$(=1)<=$(=9)"},client=> } value)

[mohamed_ahid]

Thx everybody you are awesome like always .

i have posted another question related to this one , check it out http://community.qlik.com/message/604319#604319

regards

[mohamed_ahid]

Hi,

sorry i have a question concerning your formula .

last time you have suggeted me to use :

=max({1}total

    aggr(

         sum({1<week= {">=$(=1)<=$(=9)"}> } value),

          [client]

         ) )

supposing that i add a filter in my sheet and i want to excluse the selection on my formula .

i should use the set analysis :[Field]=e([Field]) .

my question is how to use it inside the max function ?

Thx

[MayilVahanan]

Hi

Try like this

If you want to exclude the selection of the field. Then try like this

=max({1<Field = >}total

    aggr(

         sum({1<week= {">=$(=1)<=$(=9)"}, Field=> } value),

          [client]

         ) )

If you want to include the exclusion of the selection in your formula. Then try like this

=max({1<Field = e([Field])>}total

    aggr(

         sum({1<week= {">=$(=1)<=$(=9)"}, Field=e([Field])> } value),

          [client]

         ) )

[mohamed_ahid]

i have already tried this and the exclusion  is not working .

when i use the formula in a table where the exluded dimension is displayed , i still see the excluded values .