Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nivas30kumar
Contributor
Contributor

How to break the description with decimal values in qlikview

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 .

3 Replies
vishsaggi
Champion III
Champion III

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

nivas30kumar
Contributor
Contributor
Author

Hi ,

I have data like this

 

ClaimsCode1Code2Code3Code4Code5Code6
ABC12.A
SDS12.34212.5621F.45X123.456
FGG212.45212.11
HUR21.345 12.78
HIT 754.09564D.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
Creator III
Creator III

Hi,

Try something like:

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