Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
@RKULKARNI4 there are many ways to do it. other way is like below
=mid(Field,index(Field,'-')+1,len(Field)-index(Field,'-',3))
Thanks for the solution its worked for me