Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignoring the itemname which starts with special character

Hi All,

How to ignore the item name which starts with # and ~ when show in straight table or pivot table.

error loading image

9 Replies
Miguel_Angel_Baeyens

Hello,

I'd recommend you to use Purgechar() function when loading data.

Hope this helps.

Not applicable
Author

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

Not applicable
Author

The formula

=if(left(mfacname,1)<>'~' And left(mfacname,1)<>'#',mfacname)

Should be used as a dimension

Nimish

Miguel_Angel_Baeyens

Also set analysis should do it

{< mfacname -={"~*","#*"} >}


Not applicable
Author

Hi Nimish!

It works as per your suggestion. But let me know how to avoid the "-" row which is getting created because of the ignorance of the '~' and '#'. Here i want to ignore the "-" row and calculate the total of rest.

I have attached the document for your reference.

Miguel_Angel_Baeyens

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

Sum (if(left(itemname, 1) <> '~' and left(itemname, 1) <> '#', SalValue))
as expression and itemname as dimension.

Not applicable
Author

what is the username password for the file uploaded?

Nimish

Not applicable
Author

Is suppress Null value for that dimension not working for you?

Nimish

Not applicable
Author

Hi Nimish!

Its working! Forgot to select that option 😞

Thanks alot!

Regards,

Rikab