Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Ignoring the itemname which starts with special character

Hello,

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

Hope this helps.

Not applicable

Ignoring the itemname which starts with special character

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

Ignoring the itemname which starts with special character

The formula

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

Should be used as a dimension

Nimish

MVP
MVP

Ignoring the itemname which starts with special character

Also set analysis should do it

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


Not applicable

Ignoring the itemname which starts with special character

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.

MVP
MVP

Ignoring the itemname which starts with special character

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

Ignoring the itemname which starts with special character

what is the username password for the file uploaded?

Nimish

Not applicable

Ignoring the itemname which starts with special character

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

Nimish

Not applicable

Ignoring the itemname which starts with special character

Hi Nimish!

Its working! Forgot to select that option :-(

Thanks alot!

Regards,

Rikab