topic Re: Leading spaces and zeros in QlikView

Leading spaces and zeros

kulasekhar — Mon, 19 Jun 2017 16:35:08 GMT

Hi guys.

I need help on an issue. I have a view in sql server that brings two records 539681 17 and 0053968117.

These are two different items.When i make a select from that view on a qvw the result is that it brings only one of the records.

I have tried Text(ITEM_NUMBER) but it didnt work. Can anyone help?

See below Database Tale:

ITEM_NUMBER, BASELINECUT

0056729003, TERMINATED

56729003SUB1, IN_PRODUCTION

539681 17, IN_PRODUCTION

0053968117, TERMINATED

063230100511, TERMINATED

63230100511, IN_PRODUCTION

I want show data same as database with leading zeros, spaces and any caraters(56729003SUB1).

Mine showing wrong ITEM_NUMBER, are 539681 13,539681 17,539681 19,56729003,56729004,63230100511.

Please find the QVW and QVD.

Thanks

Sekhar

Re: Leading spaces and zeros

quwok — Mon, 19 Jun 2017 16:38:30 GMT

This is Qlik's automated data cleansing in action, you'll need to force the value into text using the text() function in your load script.

Re: Leading spaces and zeros

sunny_talwar — Mon, 19 Jun 2017 16:38:53 GMT

I don't see 0053968117 in your attached qvd... are you sure this row is in your qvd?

Re: Leading spaces and zeros

kulasekhar — Mon, 19 Jun 2017 16:53:29 GMT

Hi Sunny,

Can you search in ITENUM list box 539681 17. we can same ITENUM(539681 17) two BASELINECUT.

but Data base showing like this 1)539681 17, 2)0053968117

Thanks

Sekhar

Re: Leading spaces and zeros

sunny_talwar — Mon, 19 Jun 2017 17:00:57 GMT

So you need to fix this before you create the qvd... can you share the script you used to create the qvd? because one the qvd is created, there is no way to know which row belongs to which ITEMNUM.