topic Re: Left/Right Function in QlikView

Left/Right Function

Tue, 03 Feb 2015 13:24:41 GMT

Hi All

Is there a function in Qlikview equivalent to SQL Left and Right function.

I have a "~" separator and would like to get values to the left of it.

1~08-24 should return 1

125~feb 28 should return 125

Gysbert_Wassenaar — Tue, 03 Feb 2015 13:26:30 GMT

You can use the subfield for this with ~ as field separator. subfield('1~08~24', '~', 1) will return 1

robert_mika — Tue, 03 Feb 2015 13:32:48 GMT

Another Way

=TextBetween('~'&'125~feb 28','~','~')

Tue, 03 Feb 2015 13:35:55 GMT

Hi,

You can use subfield as Gysberts said / you can use Left() like this

Left(Fieldname, Index(Fieldname, '~')-1) as FieldName

Anonymous — Tue, 03 Feb 2015 13:38:14 GMT

I often use the QV mid() function as simpler alternative to the QV left() and right() functions.

Tue, 03 Feb 2015 16:07:36 GMT

Thanks a lot guys for the solution