MIN value from Aggr () returns zero

[Anonymous]

Hi all,

I am new to Qlik and starts to learn with aggr function. I would like to get the minimum sales by [province] using Min(Aggr(Count([Order ID]), Province)), but it always returns zero. The correct answer should be 79. Any ideas please?

[Anonymous · Accepted solution]

try

Min({<Province={"=Count([Order ID])>0"}>} Aggr(Count([Order ID]), Province))

[Anonymous]

It works. Thank you so much.

[Anonymous]

then close the thread please...