topic Re: RE:NewColumn in QlikView

RE:NewColumn

Chanty4u — Mon, 17 Oct 2016 09:14:34 GMT

Hi all,

I have excel with below data i need txt as new column in excel .

i tried =RIGHT(F:F,3) but it is givng 0.8 ,0.,5.2 lik dat

expected out put:

cts

pcs

Re: RE:NewColumn

Anonymous — Mon, 17 Oct 2016 09:20:04 GMT

Try this:

=trim(right('62300.800 cts',Len('62300.800 cts') - Index('62300.800 cts',' ')))

substitute '62300.800 cts' with your Field Name

Re: RE:NewColumn

Gysbert_Wassenaar — Mon, 17 Oct 2016 09:25:21 GMT

My guess is that the values in your excel file do not actually contain string values like cts and pcs, but that those are only formatting. If that's the case then you will have to change the values in excel to add the cts and pcs strings.

Re: RE:NewColumn

Anonymous — Mon, 17 Oct 2016 09:31:03 GMT

the above can be done in Qv in your load statement

Load *,

trim(right(Quantity,Len(Quantity) - Index(Quantity,' '))) As Measure

from yoursource..

Re: RE:NewColumn

sunny_talwar — Mon, 17 Oct 2016 10:12:06 GMT

I agree with Gysbert, the units might be part of the formatting rather than the value itself which might be causing this issue. Can you share your Excel file to look at it?

Re: RE:NewColumn

Chanty4u — Mon, 17 Oct 2016 13:57:38 GMT

thank you. issue got resolved.

used function

=GET.CELL(Column,'SheetName')

And =Right(Columnname,Length)

Re: RE:NewColumn

Chanty4u — Mon, 17 Oct 2016 17:17:05 GMT

let me try tommorow