Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
How to ignore the item name which starts with # and ~ when show in straight table or pivot table.
Hello,
I'd recommend you to use Purgechar() function when loading data.
Hope this helps.
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)
Nimish
The formula
=if(left(mfacname,1)<>'~' And left(mfacname,1)<>'#',mfacname)
Should be used as a dimension
Nimish
Also set analysis should do it
{< 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))
what is the username password for the file uploaded?
Nimish
Is suppress Null value for that dimension not working for you?
Nimish
Hi Nimish!
Its working! Forgot to select that option 😞
Thanks alot!
Regards,
Rikab