Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try
Min({<Province={"=Count([Order ID])>0"}>} Aggr(Count([Order ID]), Province))
try
Min({<Province={"=Count([Order ID])>0"}>} Aggr(Count([Order ID]), Province))
It works. Thank you so much.
then close the thread please...