Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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, ','))
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
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
It does work with the concat removed, but unfortunately I want to keep my concat....
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, ','))
Awesome, this works! Thank you!!!!