Remove Blank Rows In an Expression

[oliveton]

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! 

[Arthur_Fong]

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

[Brett_Bleess]

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

[oliveton]

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

[Arthur_Fong · Accepted solution]

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, ','))

[oliveton]

Awesome, this works! Thank you!!!!