19 Digits number Qlik Sense

[mvtriff]

Hi Everyone,

Can someone help me display accurately a 19 digits number into a Qlik Sense table?

For some reason, in the table, the 19 digits are displayed with 000 at the end.

Thank you.

Kind regards,

t

[acardella]

Can you provide used script?

[PrashantSangle]

Try with evaluate()

Evaluate(fieldname)

https://community.qlik.com/t5/Qlik-Design-Blog/Evaluate-Function/ba-p/1467277

Regards,

Prashant Sangle

[PrashantSangle · Accepted solution]

Looks like data is not getting properly while fetching from database only.. 

which database do you have Oracle?

Try using cast () in sql script like

LOAD id,
evaluate(iccid) as iccid_complete,
date,
cost,
data;

[stream]:

SQL  SELECT id,

cast(iccid as varchar) as iccid,
`date`,
cost,
data
FROM ebdb.stream;

Regards,

Prashant Sangle

[PrashantSangle]

Also I am moving your query to qlik sense group rather than ideation group. Also do not use num() in front end just used that field in front end

[The_Squirrel]

Hello.

Please note you can vote for this idea
https://community.qlik.com/t5/Suggest-an-Idea/Numeric-fields-on-Qlik-Sense-must-accept-more-than-14-...