topic Re: Name initials in QlikView

Name initials

Wed, 04 Dec 2013 18:01:00 GMT

Hello,

The data fields are “item #”,“sales manager”, “date” and “sales”. For example

item #	sales manager	date	sales
3	Dan Ban	1	10
3	Dan Ban	2	20
4	Dan Ban	2	30
5	Moly Demoly	1	40

I need to create a straight table with the sales manager’s initials instead of their full name. For example:

item # (dimension)	sales manager (expression)	sales (expression)
3	DB	30
4	DB	30
5	MD	40

I want to do it on the expression level, without changing the script, by using string functions. The data file contains numerous items, names and dates, but every item is associated with only one sales manager.

Any ideas?

Thanks

Re: Name initials

Gysbert_Wassenaar — Wed, 04 Dec 2013 18:06:34 GMT

If the initials are always capitalized in the full name you can try something like:

keepchar([sales manager],'ABCDEFGHIJKLMNOPQRSTUVWXYZ')

Re: Name initials

CELAMBARASAN — Wed, 04 Dec 2013 18:09:31 GMT

Hi,

Create a Field in load script like

Load

Left(SubString([sales manager], ' ', 1), 1) & Left(SubString([sales manager], ' ', 2), 1) AS [sales manager initial],

.....

Re: Name initials

Wed, 04 Dec 2013 18:43:51 GMT

nice! works perfectly.

Re: Name initials

angelaecheverri — Wed, 04 Dec 2013 18:44:24 GMT

how a Sales Name could be one, two or tree or more words you can first make a Capitalize Stament

KeepChar(Capitalize([sales manager]),'ABCDEFGHIJKLMNOPQRSTUVWXYZ')

Re: Name initials

marthacano01 — Wed, 04 Dec 2013 19:18:40 GMT

Thanks you!! very helpful

Re: Name initials

rbecher — Wed, 04 Dec 2013 20:31:36 GMT

Nice but be aware of initialising Mac, Mc and O' surnames:

Wikipedia:Reference desk/Archives/Language/2011 September 7 - Wikipedia, the free encyclopedia