topic Re: Separating feild in QlikView

Separating feild

Anonymous — Tue, 18 Jun 2013 03:15:16 GMT

hi,

i have number field like this : 015821,015822.015823...

tha last number (1) , means the position .

i want to separt the last number and make a new field that i can work with' exm:

i want to count how many positions i have for 01582 .

how do i do it ?

thanks'

yarin.

amars — Tue, 18 Jun 2013 03:37:13 GMT

Hi Yarin,

Make use of SubField(String, ',') function, which will separate all the delimiting Person with Position into separate records.

SubField(String,',') As Person_Position

Load

Person_Position,

Mid(Person_Position,1, Len(Person_Position)-1) As Person,

Right(Person_Position,1) As Position

Resident TableName

Now all your data is available use distinct count to identify the Positions for each person.

Thanks

sujeetsingh — Tue, 18 Jun 2013 03:40:55 GMT

Now if you want the last digit you can use this function as

=right(FieldName,1) this will always give you the first digit from right side.

Now you can check for 01582 as

=if(left(Fieldname,5)='01582',1,0)

This will give value 1 when condition is true else 0.

Hope it helps you.

Tue, 18 Jun 2013 06:03:55 GMT

SEE ATTACHEMENT