Numbers in a text field

[#1]

I have an Invoice No field that is alphanumeric which has numbers in it. Sometimes the numbers are repeated but to make them unique a +sign has been entered at the end -

53160

53160+

53160-

Qlikview appears to drop the invoice number with the + at the end.

I have tried Text(Inv_No)  and left(Inv_No,10) and concating an A at the beginning of the field but having no luck.

Hope someone has some advice please.

[vishsaggi]

When you say dropping you mean is it not showing in your list box. Can you share a snapshot of your issue?

[trdandamudi]

I am able to see them:

Data:
Load * Inline [
Numbers
53160
53160+
53160-
];

Result:

[#4]

But the file in the application shows -

Thanks for getting back so quickly, its the first time I've asked a question.

[el_aprendiz111]

Hi,

LOAD *, Invoice &' ' & RecNo() AS option1,
If(Invoice=Previous(Invoice), Peek(Inv2)&chr(43),Invoice) AS Inv2;

LOAD * Inline
[
Invoice
53160
53160
53160
];

[#6]

Hi,

That retrieved all the records but the invoice field has to be displayed to the user as they would recognise it. The result from your code was -

Is there a further step I can take that will give me back the '+' sign?

Thanks

[vishsaggi]

Can you trythis in your actual Load script where you pulling this Internal field.

LOAD *,

IF(ISNUM(Internal), Text(Internal), Internal) AS NewInternal;

SQL SELECT ..., Internal

FROM yoursource;

[#8]

Hi I have stripped out all my code to make sure that isn't having an issue. Your response has left justified all the values but only the 8 records are being retrieved -

[JaMajka1]

Hello Donna,

could you copy here your loading script?

what is the source? SQL DB?

BR,

Maria

[#10]

Hi ,

I have stripped it out completely to try out the above answers and this is the last one I tried-

Invoice: 
 
LOAD *,
IF(ISNUM([INTERNAL NO]), Text([INTERNAL NO]), [INTERNAL NO]) AS NewInternal

FROM
$(vSpectra_QVD_Local)ZBMHSP.qvd
(qvd);

The original data comes from an iSeries.