How to break the description with decimal values in qlikview

[nivas30kumar]

Hi,

In chart expression i am trying to concat mutiple code with alpha numeric like 123.4, A12.1 and 1234SD.45. In this i have another condition i.e After Concatenating  all the code the length should not exceed 100 characters, if it is exceeding more than 100 that should be written in separate .

Please help me from this situation .

[vishsaggi]

Can you give an eg with your expected output for that value?

[nivas30kumar]

Hi ,

I have data like this

Claims	Code1	Code2	Code3	Code4	Code5	Code6
ABC	12.A
SDS	12.34	212.56	21F.45	X123.456
FGG	212.45	212.11
HUR	21.345			12.78
HIT		754.09	564D.89
SDE						89U.76

1. Now I need to CONCAT all the codes in to 1 field and remove the extra commas where data is not there.

2. All the field length should be 100, it is crossing 100 means then i need to write in a separate field.

Ex: After Concatenating  all the fields , if my field lenth is 110 means  

Code1 should have 100 and Code2 shold have that 10 fields data.

Now i want to remove commas in fieldss where there is no data ?

How to break the field when that has 100 field length and write to next field ?

[pooja_prabhu_n]

Hi,

Try something like:

=if(len(SubField(Description,'.',2))<=100, Description,Expression)