topic Re: Qliksense Development - How to interpret an excel formula in qliksense in App Development

Qliksense Development - How to interpret an excel formula in qliksense

Himanshu22 — Thu, 05 Nov 2020 06:12:09 GMT

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 — Thu, 05 Nov 2020 06:22:56 GMT

Try with FindOneOf() function

=FindOneOf(FieldName, '.')+1

Himanshu22 — Thu, 05 Nov 2020 11:15:26 GMT

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 — Thu, 05 Nov 2020 11:27:44 GMT

You can achieve based on 2 function

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

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

Himanshu22 — Mon, 09 Nov 2020 07:37:15 GMT

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

MayilVahanan — Mon, 09 Nov 2020 10:17:44 GMT

HI @Himanshu22

Can you please close the thread.