Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
balasundaram
Creator II
Creator II

How to convert Number to Text

I Have to convert 16 digit number into text.Because Csv&Excel supports only 15digit numeric number.


ex:-

4567321789012347(qlikview) this number coming  like 4567321789012340(csv&excel) . last digit coming ZERO

17 Replies
tresesco
MVP
MVP

Text()?

ariel_klien
Specialist
Specialist

Hi,

Did you try Text(Number_Field)

BR

Ariel

Not applicable

If its the Qlik result you want use TEXT(NUMBERFIELD) AS TextNumField

ashfaq_haseeb
Champion III
Champion III

Hi

Try using num# function

num#(4567321789012347,'###########,###')

Or text function()

text(4567321789012347)

Both of them worked for me

Hope it helped.

Regards

ASHFAQ

MK_QSL
MVP
MVP

Text(YourNumberField) as YourNumberField

its_anandrjs
Champion III
Champion III

Use Text() function

Text(YourNumberField) as FieldName

balasundaram
Creator II
Creator II
Author

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

balasundaram
Creator II
Creator II
Author

Yes..

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO

balasundaram
Creator II
Creator II
Author

sample code:

b:

LOAD * INLINE [

    sno, name

    8520000197286155, chiru

    8520000197286156, pathi

];

NoConcatenate

b1:

LOAD text(sno) as sno,

name

Resident b;

DROP Table b;

STORE b1 into b.csv(txt,delimiter is ',');

In b.csv file iam getting

sno

8520000197286150,

8520000197286150

last digit coming ZERO