Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mvtriff
Contributor
Contributor

Re: 19 Digits number Qlik Sense

Hi, 

Tried the evaluate()

 

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

[stream]:
SELECT id,
iccid,
`date`,
cost,
data
FROM ebdb.stream;

 

The result is this:

mvtriff_0-1638034591482.png

 

2 Replies
Qlik1_User1
Specialist
Specialist

@mvtriff , I think its returning the value based on the values passed(in your case 'iccid').
https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

Or
MVP
MVP

https://community.qlik.com/t5/Knowledge/What-is-the-largest-numeric-value-that-can-be-loaded-in-Qlik...

Evaluate will round off the number, so it won't be the original one. If you need to maintain all the digits, I'd suggest reading the value as text rather than numeric.