topic Re: Subfield issue in QlikView

Subfield issue

fashid — Wed, 04 Feb 2015 05:08:27 GMT

Hi Everybody,

I have an issues with subfield operation .

I have a dataset which contains domin name and username in the folowing format

DOMAIN\abc

DOMAIN\xyz

DOMAIN\efg

I needed to extract just the user names so i used the subfield function

Subfield(Upper([Authenticated user]),'\') as AuthenticatedUser

The issue that i am facing here is that , when i create a list box of the AuthenticatedUser field , Along with the desired output i also get the the original rows which are along with the DOMAIN keyword

ABC

XYZ

EFG

DOMAIN\ABC

DOMAIN\XYZ

DOMAIN\EFG

Re: Subfield issue

PrashantSangle — Wed, 04 Feb 2015 05:15:50 GMT

Hi,

Try like,

Upper(Subfield([Authenticated User],'\',2))

Regards

Re: Subfield issue

Anonymous — Wed, 04 Feb 2015 05:42:56 GMT

Hi,

You need to give a third parameter in the subfiled function.

Try Subfield(Upper([Authenticated user]),'\',-1)

Regards,

Greeshma

Re: Subfield issue

avinashelite — Wed, 04 Feb 2015 05:48:01 GMT

Hi Nadeem,

If you want the 2 parameter of the sub-field then you need to pass as that as the 3 parameter

Upper(Subfield([Authenticated User],'\',2))

to get second filed we are giving it as 2, if you want 1 then give 1 respectively

Re: Subfield issue

fashid — Wed, 04 Feb 2015 06:46:36 GMT

None of them are working

Re: Subfield issue

avinashelite — Wed, 04 Feb 2015 06:50:18 GMT

please share the sample data, will see what s the issue

Re: Subfield issue

fashid — Wed, 04 Feb 2015 07:36:12 GMT

Actually the duplicate fields were coming from a table further in the script which had the same feld which led to concatenation.

Thanks for all the help guys