Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Vijesh
New Contributor

Working on Zero value

Hello,

I am facing an issue regarding a value/number starting with zeros.

I have a field named product Code, which have code numbers in numeric value which begins with zeros.

For example:

0000001

000001

while extracting to QlikView, both numbers will be store in same number (i.e. 0000001)

Product code has only unique value. in this stage after extracting I am getting duplicate values.

Please help.

 

Thanks,

V.

 

4 Replies
Highlighted
Somasundaram
Contributor III

Re: Working on Zero value

HI,

IF you you are extracting as a number, it will show based on the number format.

You can try with Text( Field_Name) while extracting data from DB source.

 

 

 

 


-Somasundaram
Highlighted
Vijesh
New Contributor

Re: Working on Zero value

Can you please explain with a qvw?

Highlighted
Partner
Partner

Re: Working on Zero value

Hi,

Looking at the attached screenshot, it looks like leading zeros are different.

Points observed:

1- One product code has 6 leading zeros while the second has 5 leading zeros. To resolve this, your dba can update the product code or ask why product code leading zeros are different.

2- The Product is different so this will cause the duplicate, as in A & B.

You can attached data file, i.e. excel for further investigation.

Highlighted
vvira1316
Valued Contributor II

Re: Working on Zero value


LOAD Text(StrNum) as StrNum
FROM
[NumTest.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

 

num.PNG       num.PNG