topic How can i avoid the unwanted data? in QlikView

How can i avoid the unwanted data?

Wed, 21 Mar 2012 07:50:47 GMT

Hi All,

1888782027( 2011-11-30T20:51:53.8870000 )|

1888791215( 2011-11-30T21:07:55.3330000 )|

1888803241( 2011-11-30T21:26:20.9060000 )|

1888803846( 2011-11-30T21:27:43.8350000 )|

1889406845( 2011-11-30T22:57:56.1880000 )|

1889432705( 2011-11-30T23:34:49.2880000 )|

1889436151( 2011-11-30T23:41:05.9830000 )|

1889448982( 2011-12-01T00:02:58.6130000 )

The above one is the data hold in a variable for a particular field selections.

But i need to avoid the data which i elevate in a differant colour.

How can i do this?

Regards

.........

Wed, 21 Mar 2012 08:08:53 GMT

The length of the Data you want to keep is 10 so you can use

let new_variable = right(variable,10);

Wed, 21 Mar 2012 09:02:20 GMT

Hello,

I don't want the right side data,I want the left side data.

instead of 'right(variable,10)' , i have used 'left(variable,10)'

If i use like this i am not able to get the all the values.It is showing only the first value.

Hope you understand.

Regards

.......

CELAMBARASAN — Wed, 21 Mar 2012 09:08:49 GMT

Hi,

How you stored it in variable?using concat?

if so you can apply to it inside the concat itself like Concat(Left(FieldName,10),'|')

Celambarasan