Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Numeric format

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi,

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!

7 Replies
Anonymous
Not applicable
Author

Thanks Sunny!

Partner - Master II

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.

Specialist

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

Anonymous
Not applicable
Author

Hi,

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!

Specialist

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
Not applicable
Author

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?