topic Seperate a field/column in a table in QlikView

Seperate a field/column in a table

Wed, 01 Feb 2012 09:19:32 GMT

Hello,

i need some help. My problem is:

i have a field/colum names TEST that contains for example:

A 1s

A 1r

A 12s

A 12r

I want now a table, that contains A, 1 or 12, r/s as columns.

I tried left(TEST,1) as column1,

mid(TEST,3,1) as column2,

right(TEST,1) as column3.

My problem is now, that the value 12 in column is showed as 1 because of mid(TEST,3,1).

How can i change the function to show the value 12?

Thank you for your help!

CELAMBARASAN — Wed, 01 Feb 2012 09:25:53 GMT

Hi,

For that use this expression

mid(TEST,3,len(TEST)-3)

Celambarasan

Wed, 01 Feb 2012 09:38:13 GMT

Thank you very much! It works!