topic Re: elimenate first character for data in QlikView

elimenate first character for data

gidon500 — Wed, 30 May 2012 11:07:54 GMT

Hi I have a filed which includes serial no of computers in order to make my reprot i need to get the serial number without the first charater for exp. SENNO. SCHC900 should be CHC900 or SZ100 should be Z100

thanks for your help

gidon

Re: elimenate first character for data

Miguel_Angel_Baeyens — Wed, 30 May 2012 11:14:54 GMT

Hi Gidon,

Use Left() and Len() functions to get it:

Right([Serial Number], Len([Serial Number]) -1) AS SerialWithoutFirstChar

Hope that helps.

Miguel

elimenate first character for data

m_woolf — Wed, 30 May 2012 11:17:14 GMT

If you want to change the serialNo in script:

mid(SerialNo,2,len(SerialNo)-1) as SerialNo

In a chart expression:

mid(SerialNo,2,len(SerialNo)-1)

elimenate first character for data

gidon500 — Wed, 30 May 2012 11:44:23 GMT

Hi miguel thaks for your fast response it works great thanks gidon

Re: elimenate first character for data

magavi_framsteg — Wed, 30 May 2012 11:44:48 GMT

Hi Gidon.

It would be sufficient to use the mid function with two parameters, like below:

mid([Serial Number], 2) as [Serial Number]

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Re: elimenate first character for data

Miguel_Angel_Baeyens — Wed, 30 May 2012 12:03:59 GMT

Magnus,

I agree: easier, cleaner and simpler.

Miguel