topic Re: Abbrevation for Name in QlikView

Abbrevation for Name

Anonymous — Fri, 29 Jan 2016 07:27:28 GMT

Hello Qlikers,

I am having a list of Name say:

NAME

Balraj Ahlawat

Sunny T

Jagan Mohan

M G

Now I want one more field which should give me Capital Alphabhats from that list, like

NAME Abbrev

Balraj Ahlawat BA

Sunny T ST

Jagan Mohan JM

M G MG

From my point fo view I thought of Loop inside Loop, i.e

For i=1 to NoOfRows(Table)

let Vlength=len(Name(i));

For j=1 to $(Vlength)

What should be my condition now to fetch capital alphabats only??

next j

Next i;

Or is their any other alternate or simple way for same?

Regards,

Balraj Ahlawat

Re: Abbrevation for Name

jagan — Fri, 29 Jan 2016 07:36:05 GMT

Hi,

Try like this using SubField() and Concat().

Data:

LOAD

NAME,

Concat(Temp) AS Abbrev

GROUP BY NAME;

LOAD

NAME,

Left(SubField(NAME, ' '), 1) AS Temp

INLINE [

NAME

Balraj Ahlawat

Sunny T

Jagan Mohan];

Regards,

Jagan.

Re: Abbrevation for Name

jonathandienst — Fri, 29 Jan 2016 07:42:57 GMT

You could use KeepChar('ABCDEFGHIJKLMNOPQRSTUVWXYZ') to keep only the capitals

Re: Abbrevation for Name

Anonymous — Fri, 29 Jan 2016 07:56:01 GMT

Jagan,

what If I am having name like?

Balraj AhlaWAt

SuNNy T

JaGan MoHan

In this case subject of this thread will not match

But what I am looking for, If I get any upper alphabat in string it should display those alphabats.

Re: Abbrevation for Name

Anonymous — Fri, 29 Jan 2016 07:58:53 GMT

Yes, I already did & was working well. But looking for more alternates

Re: Abbrevation for Name

jagan — Fri, 29 Jan 2016 08:04:40 GMT

I thought you just want first character of each word. If you just want Capital letters then best thing is use Keep() like below

KeepChar(FieldName, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')

Re: Abbrevation for Name

Anonymous — Fri, 29 Jan 2016 08:09:34 GMT

Okay, Is this the only way to achieve same?

Re: Abbrevation for Name

flipside — Fri, 29 Jan 2016 08:22:40 GMT

... and just wrap Capitalize in this expression around FieldName if just the 1st char of each word is needed (in caps).

Re: Abbrevation for Name

jagan — Fri, 29 Jan 2016 08:26:05 GMT

There are ways but it is the easiest and simpler one. Otherwise you need to use Nested loops and compare, its a tedious process.

Regards,

Jagan.

Re: Abbrevation for Name

Fri, 29 Jan 2016 09:33:18 GMT

Hi balraj,

try like this

load *, left((SubField(NAME,' ',1)),1)&''&left((SubField(NAME,' ',2)),1) as term

INLINE [

NAME

BalRaJ Ahlawat

Sunny T

Jagan Mohan

];

may be helpful for you