topic Re: Removing last 7 characters in QlikView

Removing last 7 characters

Anonymous — Thu, 05 May 2016 19:30:43 GMT

I am trying to remove last 7 characters from a string but my expression does not work , can someone take look at it

Thanks

sunny_talwar — Thu, 05 May 2016 19:31:51 GMT

Usually something like this should work:

Left(FieldName, Len(FieldName) - 7))

sunny_talwar — Thu, 05 May 2016 19:33:45 GMT

Try this:

Left(SummaryTargets.key, Len(Trim(SummaryTargets.key)) - 7)