How to ignore the item name which starts with # and ~ when show in straight table or pivot table.
Try using the following formula if you do not want to show the mfacnames which starts with either # or ~.
=if(left(mfacname,1)<>'~' And left(mfacname,1)<>'#',mfacname)
Yep, it won't work (not with that syntax) since "~" prepending character have different means in QlikView (i. e.: used in Set Analysis to exclude results). You are getting that null value because those articles exists in your search, but their values are not displayed (that was why I was looking for set analysis search instead).
So until new lights are shed on escaping characters in set analysis (should it is possible), this will work, not showing any null value
as expression and itemname as dimension.Sum (if(left(itemname, 1) <> '~' and left(itemname, 1) <> '#', SalValue))