Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.