topic Use index-function to show a negative number in QlikView

Use index-function to show a negative number

Fri, 03 Feb 2012 09:47:04 GMT

Hello,

i have a field that contains:

Hello -10 Temperature today

i use this functions to show the value -10. But it doesn't work:

mid(field,index(field,-10,),len(-10))

i tried this one, too: mid(field,index(field,'-'&10),len('-'&10)).

Can anyone help me please? Thanks!

Fri, 03 Feb 2012 09:52:29 GMT

Hi,

try to include your pattern into single quotes like this:

mid(field,index(field,'-10',),len('-10'))

HtH

Roland

Fri, 03 Feb 2012 10:08:58 GMT

Hi,

Try yhe keepchar Function:

keepchar (fiekd,'-0123456789' )

Hoe thet ehat you want.