Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

fabianaiglesias
Contributor

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
fabianaiglesias
Contributor

Re: Numeric format

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!

7 Replies
MVP
MVP

Re: Numeric format

fabianaiglesias
Contributor

Re: Numeric format

Thanks Sunny!

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

Any aditional comment?

ogster1974
Honored Contributor II

Re: Numeric format

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
Valued Contributor

Re: Numeric format

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

fabianaiglesias
Contributor

Re: Numeric format

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
Valued Contributor

Re: Numeric format

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.

fabianaiglesias
Contributor

Re: Numeric format

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?