Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Concatenate column

Hello Team,

I have one column example :"1231-M2005003681-AC-1-20200424-12477"

1231 : 1
M2005003681 : 2
AC : 3
1 : 4
20200424 : 5
12477 :6

I need to display only 2,3 & 4 only .How it can be done in Qliksense.Please advise.

 

Regards

RK

1 Solution

Accepted Solutions
Gui_Approbato
Creator II
Creator II

Hello,

You can use the Subfield function.

Subfield(Column, '-', 1 )   --> '-' is the delimiter, and 1 is the part that you want to grab from it.

View solution in original post

3 Replies
Gui_Approbato
Creator II
Creator II

Hello,

You can use the Subfield function.

Subfield(Column, '-', 1 )   --> '-' is the delimiter, and 1 is the part that you want to grab from it.

View solution in original post

Kush
MVP
MVP

@RKULKARNI4  there are many ways to do it. other way is like below

=mid(Field,index(Field,'-')+1,len(Field)-index(Field,'-',3))
RKULKARNI4
Contributor III
Contributor III
Author

Thanks for the solution its worked for me