topic Re: Ignoring blank values in QlikView

Ignoring blank values

skiruthigadevi — Thu, 21 Nov 2019 21:52:25 GMT

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!

Re: Ignoring blank values

Arthur_Fong — Tue, 03 Dec 2019 03:04:45 GMT

Try this:

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

Re: Ignoring blank values

Brett_Bleess — Thu, 05 Dec 2019 17:04:41 GMT

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