Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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()??
Here you can find the file of Qlikview with an example of my data
I hope you can help me.
thanks
What was the issue? Can you convert into English. If not fluent, Take help from others. So that, i may can read your message
Can you check this, I am not sure i understand the issue
=sum({< No.Registro = {"$(=Max([No.Registro]))"} >} [Inventario (Unidades)])
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
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
Try
=sum({< No.Registro = {"$(=Max(TOTAL <description> [No.Registro]))"} >} [Inventario (Unidades)])
it do the same
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?