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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. 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.