Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Qlik Sense has a problem storing data when there leading zeroes

Hi Qlik Community,

I notice that when the values of the UPC are identical except for for the leading zeroes, Qlik just grab the first value.  In this example, the one highlighted in yellow is replaced with the one on top?

Please advise how I can fix this?

1 Solution

Accepted Solutions
MVP
MVP

Re: Qlik Sense has a problem storing data when there leading zeroes

Try to load your values as text

LOAD

     Text(upc) as upc,

3 Replies

Re: Qlik Sense has a problem storing data when there leading zeroes

Try may be this:

Num(upc) as upc

or

upc * 1 as upc

MVP
MVP

Re: Qlik Sense has a problem storing data when there leading zeroes

Try to load your values as text

LOAD

     Text(upc) as upc,

dverbeke
Contributor III

Re: Qlik Sense has a problem storing data when there leading zeroes

or try set verbatim = 1

Community Browser