Numbers appearing in different format.

[nickmarlborough]

I have a table (from excel) that I have added to QlikSense.

example of format:

034G111

078F255

067E789

When I add this to QlikSense some of the numbers remain correctly in that format however for some they go to a format like 034 + G + 111 (so scientific notation)

how do I keep all in the same format they appear in excel?

[brunobertels]

hi 

try 

text(yourfield)  

[nickmarlborough]

Where would I type this??

[brunobertels]

Hello 

In the load script : 

load 

A,

B,

text(C) as C // where C is your fiel with those values type (034G111) 

...

From 

In an object ( Table Cross table etc ) 

just add in dimension or mesure 

text(C)

[nickmarlborough]

Thank you all for your responses. Please forgive my ignorance. I have a couple questions off the back of these replies. 

At the moment I have not used the Load Editor. At the moment my data is being imported through the Data Manager (importing Excels from saved locations on my desktop). In the load editor therefore there is a section saying 'Auto generated section' which appears as locked (I have the option to unlock but yet to do so as unsure of negative effect).

1. Would you recommend Unlocking this loaded data and editing the script in there?

2. The LOAD function.....is this a way to import tables from the data saved in your desktop? (as an alternative to importing through the data manager? with the '+' sign.

3. when you say LOAD.... and then FROM... would the FROM be the file path of where the document is currently saved down?

Thank you, really appreciate the help

[brunobertels]

Hello 

1 : Yes you can clik the unlock button and then transform adapt modufy your script : 

here below an example of an auto generate script transformed after unlocking it : 

you can rename a field eg :[CCAS] as [SUP] 

Transform field :

Capitalize([Collaborateurs]) as [Collaborateurs],

convert field to formating date : 

month(date#([MOIS],'MMMM')) as MOIS,

2 : Yes also , in script editor click on the + button 

then at the left of screen you have the data connexion menu 

you can create a new connection 

Or load a new file using existing connection by cliking on this icon 

3 Yes too 

see help page for details 

https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularSt... 

The LOAD statement loads fields from a file, from data defined in the script, from a previously loaded table, from a web page, from the result of a subsequent SELECT statement or by generating data automatically. It is also possible to load data from analytic connections.

from is used if data should be loaded from a file using a folder or a web file data connection.

file ::= [ path ] filename

Example: 'lib://Table Files/'

Hope it helps and welcome to Qlik 🙂