topic Re: Splitting string in QlikView

Splitting string

Thu, 16 Feb 2012 07:54:22 GMT

Hi ,

I am displaying the chart title dynalically. i am using getFieldSelections(field) which gives results like 0430-ABC, 0554-ABC, 0676-BBC, 0823-CAB, 0875-GAP, 0909-CHD.

but i want display the chart title like B0430,B0554,B0676,B0823,B0875,B0909.

How i will split the string 430-ABC, 0554-ABC, 0676-BBC, 0823-CAB, 0875-GAP, 0909-CHD. and get the values like in the following format

B0430,B0554,B0676,B0823,B0875,B0909.

Splitting string

vijay_iitkgp — Thu, 16 Feb 2012 08:18:47 GMT

You can use B&Subfield(Field1,'-',1)

Re: Splitting string

v_iyyappan — Thu, 16 Feb 2012 08:22:49 GMT

Hi,

use the label ='B'&''&left(field,4) .You will get the 'B' with first foru digit of Character i.e( B0430 )

Regards,

Iyyappan.

Splitting string

Thu, 16 Feb 2012 08:26:12 GMT

This will give only one value(0430), but i want all the values should dispaly

Splitting string

lironbaram — Thu, 16 Feb 2012 08:33:50 GMT

you can use

concat(distinct 'B' & left(Field,4),',')

Re: Splitting string

v_iyyappan — Thu, 16 Feb 2012 08:39:53 GMT

Hi,

I attach sample QV file.

Regards,

Iyyappan.

Splitting string

vijay_iitkgp — Thu, 16 Feb 2012 08:40:32 GMT

use

Concat(Distinct B&Subfield(Field1,'-',1),',')

Splitting string

Thu, 16 Feb 2012 08:53:04 GMT

it's working. Thank you very much.