get min of rows

[stoneB]

Bonjour, 

I have an array, I would like to retrieve the min of the value and the value of the associated dimensions as follows.

I would like as results

Qlik Sense Business #script 

[vchuprina]

Hi,

The script below will add a column with min value to your table.

Then you can use it in your charts

TMP:
LOAD
     NameApp,
     DimesionDescription,
     Value
FROM yoursource;

Left Join(TMP)
LOAD
     NameApp,
     Min(Value) as MinValue
Resident TMP
Group By NameApp;

Also, you can leave in the table only a row with min value 

TMP:
LOAD
     NameApp,
     DimesionDescription,
     Value
FROM yoursource;

Inner Join(TMP)
LOAD
     NameApp,
     Min(Value) as Value
Resident TMP
Group By NameApp;

Regards,

Vitalii

[stoneB]

Thank you for your answer, the value is an aggregation of another dimension and a variable. The only way for me to do this is with a calculated expression. I searched the community without finding an answer.