Numeric format

[Anonymous]

Hi!

I have an excel file as a data source and I need to import a 17-digit numerical field into Qlik Sense, but in doing so, the import is done by displaying the number according to the scientific notation

How can I do to see the 17 digits?

[sunny_talwar]

See if this helps in any way

Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. T...

[Anonymous]

Thanks Sunny!

I read your comment but I´m not sure about how to solve this problem.

Any aditional comment?

[ogster1974]

As its an identifier field could you split it using left and right functions along logical identification lines.  

Looks like the first 12 digits are used.

[zebhashmi]

Div(IDAccount, '1e10') & left(repeat('0',10), 10 - len(text(Mod(IDAccount, '1e10')))) & Mod(IDAccount, '1e10') as IDAccount,

[Anonymous · Accepted solution]

Hi,

I modified your script to

Div(IDAccount, '1e10') & left(repeat('0',10), 10 - len(text(Mod(IDAccount, '1e10')))) & Mod(IDAccount, '1e10') as Account,

and it worked

First of all, I had to chage cell format in excell from numeric to general

Thanks!

[zebhashmi]

Thank you for sharing That yes it was changing the last two digits as it is remainder of the number.

Glad you were able to fix it.

[Anonymous]

HI again,

I´m working in another project with codes and I applied the @Jahanzeb Hashmi solution to managed the same problem, but it didn´t work this time: some codes match with the ones in excel (column C, green codes) and some don´t (column C, red codes).

Any idea to solve this problem?