Aggr SetAnalysis

[Vittore8]

I need to get the minimum value from column F by excluding the values of column F where column E is empty

please tell me how to do this using set analysis

[raji6763]

hi @Vittore8 ,

you can try this

load*inline [
E,F
a,12
b,3
c,2
d,4
,5
,3
,3

]
where len(E)>0;

then use min(F) in set analysis

[Taoufiq_Zarra · Accepted solution]

Maye be :

=Min({<E={"=len(E)>0"}>} F)

output :

[Vegar · Accepted solution]

Try this:

=Min({<E={"*"}>} F)

(Assuming that E is null() or missing when empty) 

[tresesco]

Please refrain from posting duplicate threads. Did you try the solution I proposed here: https://community.qlik.com/t5/New-to-Qlik-Sense/MinString-Date/m-p/1726354/highlight/false#M167405 ?