topic Re: Joins with numeric(28,0) fields in QlikView https://community.qlik.com/t5/QlikView/Joins-with-numeric-28-0-fields/m-p/1201120#M880562 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P><A href="https://gist.github.com/ralfbecher/6550467" title="https://gist.github.com/ralfbecher/6550467">Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. The 64-bit IEEE float…</A></P></BODY></HTML> Tue, 04 Oct 2016 16:28:26 GMT sunny_talwar 2016-10-04T16:28:26Z Joins with numeric(28,0) fields https://community.qlik.com/t5/QlikView/Joins-with-numeric-28-0-fields/m-p/1201119#M880560 <HTML><HEAD></HEAD><BODY><P>Hi I need some Help...</P><P></P><P>I'm trying to join 2 tables via a numeric (20,0) field. However Qlik does not seem to like this.</P><P>it seems to conver the number as per below.</P><P>From: 5395072177213114882675115911</P><P>To: 5.3950721772131e+027</P><P>I've also tried chopping up the number using Left, Mid &amp; Right as per below.</P><P></P><P></P><P>Left(PRIMARYATTACHMENTID,7)&amp;'-'&amp;Mid(PRIMARYATTACHMENTID,7,7)&amp;'-'&amp;Mid(PRIMARYATTACHMENTID,7,7)&amp;'-'&amp;Right(PRIMARYATTACHMENTID,7) as ATTACHMENTID</P><P></P><P>Any Ideas????</P><P></P><P>Thanks in Advance<BR /> </P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Joins-with-numeric-28-0-fields/m-p/1201119#M880560 Anonymous 2020-11-25T16:16:04Z Re: Joins with numeric(28,0) fields https://community.qlik.com/t5/QlikView/Joins-with-numeric-28-0-fields/m-p/1201120#M880562 <HTML><HEAD></HEAD><BODY><P>See if this helps:</P><P><A href="https://gist.github.com/ralfbecher/6550467" title="https://gist.github.com/ralfbecher/6550467">Loading numbers in QlikView with more than 14 digits leads into scientific (exponential) notation. The 64-bit IEEE float…</A></P></BODY></HTML> Tue, 04 Oct 2016 16:28:26 GMT https://community.qlik.com/t5/QlikView/Joins-with-numeric-28-0-fields/m-p/1201120#M880562 sunny_talwar 2016-10-04T16:28:26Z