Valor maximo en set analysis para tabla pivote

[Anonymous]

good day

I'm new to qlikView:

I am trying to calculate in a table the maximum value of a field to use it in a set of analysis,

I calculate the maximum value per dimension (maxString) I get the expected result, but only the maximum data of the entire table, in the others it is "0"

The set analysis only calculates the maximum value of the field RegistroNum and not of the others,

What formula can I use to calculate the maximum field of each dimension?

I already tried with a sum aggr but it does not give me results

regards

[Anonymous]

I can´t find the way to attach here it,

I leave the wetransfer link,

WeTransfer

[vinieme12]

Add [No.Registro] to AGGR and check

SUM( AGGR (

                    if(No.Registro = Max(TOTAL <description> [No.Registro]) , [Inventario (Unidades)]),Description,[No.Registro])

     )

How to attach a file to thread

[Anonymous]

The file is already available

I do not know if QlikView has a function similar to vlookup (excel)

where I can bring the field I need with reference; Max ([No.Registro])

I want to say something like lookup () but in the table not in the script

[vinieme12 · Accepted solution]

the above expression is working for me

SUM( AGGR (
  if(No.Registro = Max(TOTAL <Descripción> [No.Registro]) , [Inventario (Unidades)]),Descripción,[No.Registro])
  )

Attaching updated QVW

[Anonymous]

Thank you very much,

Now i know i was wrong when i tried that,

my expression is wrong per the parenthesis,

I would never have discovered the solution on my own,

Really thanks