topic Subfield within subfield not working in QlikView

Subfield within subfield not working

Mon, 13 Feb 2017 07:31:14 GMT

I have a string which is like

1.1 deposits

when I use the below code

SubField((SubField([Line Description],' ', 1)), '.', 1) as LEVEL1

the output of 1.1 deposits should be 1. However, it is not working. How do I make this work? thanks

Re: Subfield within subfield not working

kaushiknsolanki — Mon, 13 Feb 2017 07:40:26 GMT

Hi,

You dont need 1 Deposits ..?

Please explain the logic in details.

Regards,

Kaushik Solanki

Re: Subfield within subfield not working

surendraj — Mon, 13 Feb 2017 07:44:00 GMT

From the above what is your expected output?

Re: Subfield within subfield not working

Mon, 13 Feb 2017 07:44:38 GMT

Basically I would like to just extract the first digit before the first decimal point. So if the string is "5.6 Assets", I would like the value 5. If the string is "12.44.7 Liability", I would want 12.

Re: Subfield within subfield not working

Mon, 13 Feb 2017 07:46:30 GMT

I have a string which is like

1.1 deposits

2.1 assets

55.1 liability

my expected output will be

Re: Subfield within subfield not working

surendraj — Mon, 13 Feb 2017 07:47:03 GMT

Why can't you simply try with..

SubField('12.44.7 Liability','.', 1)

Re: Subfield within subfield not working

surendraj — Mon, 13 Feb 2017 07:48:26 GMT

Try with..

SubField([Field name],'.', 1)

Re: Subfield within subfield not working

Peter_Cammaert — Mon, 13 Feb 2017 08:00:26 GMT

AFAIK your original code works like a charm. Are you sure about the actual content of field [Line Description] ?

Note: to make sure that I use the same code as you did, I copy/pasted your script line into the editor.

Of course, surendra j already posted a shorter version that produces the same output.

Re: Subfield within subfield not working

surendraj — Wed, 15 Feb 2017 15:35:59 GMT

Please Close the thread..if you got the relevant one..

It will be useful to community members.