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

[vinieme12]

can you post a data sample in excel ? and the expressions and dimensions you are using

do you want to see max by the value returned by maxstring()??

[Anonymous]

Here you can find the file of Qlikview with an example of my data

I hope you can help me.

thanks

Example.qvw - Google Drive

[Anil_Babu_Samineni]

What was the issue? Can you convert into English. If not fluent, Take help from others. So that, i may can read your message

[Anil_Babu_Samineni]

Can you check this, I am not sure i understand the issue

=sum({< No.Registro = {"$(=Max([No.Registro]))"} >} [Inventario (Unidades)])

[Anonymous]

thanks,

I need this information in the table:

The value of the field [Inventario (Unitdades)]

only if it corresponds to the maximum value of the field "No.Registro"

this for each dimension,

actually the expresion that i use, only do this with the max value of all the table, but i need this for each dimension

i tried with Sum(Aggr()) and with max() and MaxString() but it doesn´t work,

for more specification here is the file:

https://drive.google.com/file/d/0B5Vh0Cg_kmH5WDF2Mm9QODVSS0k/view?usp=sharing

[Anonymous]

I tried that,

but it does not work, it only calculates the maximum value of the table,

but not the rest of the dimension

If I select only one description, the result is expected, but not when I have not selected anything

[vinieme12]

Try

=sum({< No.Registro = {"$(=Max(TOTAL <description> [No.Registro]))"} >} [Inventario (Unidades)])

[Anonymous]

it do the same

[vinieme12]

Try;

SUM( AGGR (

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

     )

I'm not able to open GDrive,can you attach here?