Qliksense Development - How to interpret an excel formula in qliksense

[Himanshu22]

Hi All,

There is a formula in excel which I need to add in qlikense develpoment . Below is the formula,

=IFERROR(FIND(".",A3),0)+1

How this can be done in qliksense?

[MayilVahanan]

HI @Himanshu22 

Try with FindOneOf() function

=FindOneOf(FieldName, '.')+1

[Himanshu22]

Hi @MayilVahanan 

Thanks for this. Actually suppose if there are there is a column in  excel like 

xysjksmsldn.1200_ABC - XYXMX , then I want value 1200 from this, i.e after "." and before "-"

and if the value is like ABC - klsdjlskjslkj  then I want the value ABC from this, i.e before "-".

The formula used in excel is:

=IFERROR(FIND(".",A2),0)+1

=IFERROR(FIND(" -",A5),50)

Could somethind be done here?

[MayilVahanan]

Hi @Himanshu22 

You can achieve based on 2 function

TextBetween('xysjksmsldn.1200_ABC - XYXMX', '.','-')

SubField('ABC - klsdjlskjslkj', '-',1)

[Himanshu22 · Accepted solution]

Hi @MayilVahanan ,

Thanks for this. It was very useful and I was able to fulfill my requirement with the help of this.

[MayilVahanan]

HI @Himanshu22 

Can you please close the thread.