topic Re: Splitting a field in QlikView

Splitting a field

Mon, 24 Aug 2015 08:56:05 GMT

Hi Experts,

I have a dimension field which has Alphanumeric data

like 79342-John Albert (i have a hyphen in between)

i need to separate into two. one with numeric data and other with the Alphabets

like Field1 - 79342

Field2 - John Albert

Is it possible to split?

How can i do this. pls help

Re: Splitting a field

arulsettu — Mon, 24 Aug 2015 09:00:17 GMT

try like this

SubField('79342-John Albert',2) as numericfield,

SubField('79342-John Albert','-',2) as textfield

Re: Splitting a field

Mon, 24 Aug 2015 09:00:46 GMT

i need to do this on pivot table and not on script.

pls help

Re: Splitting a field

tresB — Mon, 24 Aug 2015 09:01:22 GMT

SubField('79342-John Albert','-',1)

SubField('79342-John Albert','-',2)

And this can be used in pivot table(or anywhere at the front-end)

You can use field name instead of the string.

Re: Splitting a field

Mon, 24 Aug 2015 09:02:18 GMT

Hi,

thanks for the response

the example is the field value not the field name

Re: Splitting a field

kaushiknsolanki — Mon, 24 Aug 2015 09:04:52 GMT

Hi,

Yes its possible.

You can use the subfield function to get the separate fields.

Load Old_Field_Name,

SubField(Old Field Name,'-',1) as Field1,

SubField(Old Field Name,'-',1) as Field2

From XYZ;

Regards,

Kaushik Solanki

Re: Splitting a field

alex_millan — Mon, 24 Aug 2015 09:06:35 GMT

Hi,

create two calculated dimensions on your pivot table:

SubField('79342-John Albert','-',1)

SubField('79342-John Albert','-',2)

HTH

Regards