Ignoring blank values

[skiruthigadevi]

Hello Friends,

I have an expression below but its including my blank records as well, is there any way to eliminate it?

could you kindly let me know?

expression:

count(Aggr(If(Sum(Qty)>=4.000,1), multi))

thank you!

[Arthur_Fong]

Try this:

count(if(not isnull(Aggr(If(Sum(Qty)>=4.000,1), multi)),Aggr(If(Sum(Qty)>=4.000,1), multi)))

[Brett_Bleess]

Skiruthigadevi, did Arthur's idea work for you?  If so, please be sure you return to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this did work for the use case.  If you still require further assistance, leave an updated comment.

Here is a Design Blog post that may help too:

https://community.qlik.com/t5/Qlik-Design-Blog/Excluding-values-in-Set-Analysis/ba-p/1471704

That might be another way to go at things.

Regards,
Brett