topic Re: Remove Blank Rows In an Expression in QlikView

Remove Blank Rows In an Expression

oliveton — Sat, 16 Nov 2024 02:39:03 GMT

I have some columns where data (dimension) is present, but have nothing in the 3 expression cells.

I want to remove all rows that are blank for the 3 expression columns "FelPro', "OH" and "SalesTotal."

I can't use suppress when value is null because it messes up my expressions.

Thanks for taking a look!

Re: Remove Blank Rows In an Expression

Arthur_Fong — Tue, 27 Aug 2019 01:16:21 GMT

Remove the concat in your expressions.

Concatenating will creates non-null strings even when you do not have data in your table.

Refer qvw attached for more info.

Thanks and regards,

Arthur Fong

Re: Remove Blank Rows In an Expression

Brett_Bleess — Wed, 04 Sep 2019 14:07:49 GMT

Natalie, did Arthur's tweak to your app address your issue? If so, please consider using the Accept as Solution button on his post to give him credit as well as let others know this worked for you.

Regards,
Brett

Re: Remove Blank Rows In an Expression

oliveton — Wed, 04 Sep 2019 14:15:00 GMT

It does work with the concat removed, but unfortunately I want to keep my concat....

Re: Remove Blank Rows In an Expression

Arthur_Fong — Wed, 04 Sep 2019 14:47:45 GMT

Try this in each expression:

if(len(Concat(FP, ';'))<1,null(),Concat(FP, ';'))

if(len(Concat(OnHand, ','))<1,null(),Concat(OnHand, ','))

if(len(Concat(TotalSales, ','))<1,null(),Concat(TotalSales, ','))

Re: Remove Blank Rows In an Expression

oliveton — Wed, 04 Sep 2019 17:28:37 GMT

Awesome, this works! Thank you!!!!