topic Ignoring the itemname which starts with special character in QlikView

Ignoring the itemname which starts with special character

Mon, 25 Jan 2010 13:27:18 GMT

Hi All,

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

Ignoring the itemname which starts with special character

Miguel_Angel_Baeyens — Mon, 25 Jan 2010 14:00:03 GMT

Hello,

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

Hope this helps.

Ignoring the itemname which starts with special character

Mon, 25 Jan 2010 15:34:51 GMT

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

Ignoring the itemname which starts with special character

Mon, 25 Jan 2010 15:38:03 GMT

The formula

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

Should be used as a dimension

Nimish

Ignoring the itemname which starts with special character

Miguel_Angel_Baeyens — Mon, 25 Jan 2010 16:26:39 GMT

Also set analysis should do it

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

Ignoring the itemname which starts with special character

Wed, 27 Jan 2010 06:38:56 GMT

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.

Ignoring the itemname which starts with special character

Miguel_Angel_Baeyens — Wed, 27 Jan 2010 08:35:11 GMT

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.

Ignoring the itemname which starts with special character

Wed, 27 Jan 2010 10:19:56 GMT

what is the username password for the file uploaded?

Nimish

Ignoring the itemname which starts with special character

Wed, 27 Jan 2010 10:24:35 GMT

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

Nimish

Ignoring the itemname which starts with special character

Wed, 27 Jan 2010 10:53:22 GMT

Hi Nimish!

Its working! Forgot to select that option 😞

Thanks alot!

Regards,

Rikab