topic Re: Display last value in a string in QlikView

Display last value in a string

Mon, 15 Jun 2015 09:13:52 GMT

Hi All,

hope you could help me with the following issue.

lets say I have a field which contains the following values:

'ABC>AB>A'

'ABCD>ABBBC>AD>D'

'MMMN>MKL>KLL>KLLL>L'

I want to create a new dimension that will display the values after the last '>' (the result will be: 'A','D','L'). I don't know how many characters will be before the last '>'.

is there a function I can use?

Hope I was clear enough.

thanks in advance

Re: Display last value in a string

antoniotiman — Mon, 15 Jun 2015 09:20:54 GMT

Hi Michal,

=Subfield('AAA>BBB>ACCC >L','>',-1)

Regards,

Antonio

Re: Display last value in a string

PrashantSangle — Mon, 15 Jun 2015 09:26:01 GMT

hi,

Try this

subfield('MMMN>MKL>KLL>KLLL>L','>',len(KeepChar('MMMN>MKL>KLL>KLLL>L','>'))+1)

replace string with field

Regards

Re: Display last value in a string

Mon, 15 Jun 2015 10:17:56 GMT

Thank you!