Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siva_boggarapu
Contributor II

Missing data

Hi Team,

I have data like below

000021000

000031000

When I am loading data into Qlik Sense

The data appearing like

21000 and 31000 but I want data as it is like 000021000,000031000..

Thanks,

Siva

1 Solution

Accepted Solutions
JustinDallas
Valued Contributor II

Re: Missing data

Is it from an Excel spreadsheet?  That can create problems in other technologies I've seen.  In any case, try using the Text() function

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/Interpretation...

Something like this:

LOAD

     Text(somefield) AS somefield,

     Text(nextfield) AS nextfield

FROM ...

4 Replies

Re: Missing data

May be load as Text?

Text(FieldName) as FieldName

JustinDallas
Valued Contributor II

Re: Missing data

Is it from an Excel spreadsheet?  That can create problems in other technologies I've seen.  In any case, try using the Text() function

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/Interpretation...

Something like this:

LOAD

     Text(somefield) AS somefield,

     Text(nextfield) AS nextfield

FROM ...

Highlighted
siva_boggarapu
Contributor II

Re: Missing data

Hi Justin,

Thanks for reply.. Its working fine

Thanks

Siva

Re: Missing data

What was not right about my response siva.boggarapu

Forget it