topic Re: Qlik Sense is adding zeros to importet values in App Development

Qlik Sense is adding zeros to importet values

Oliver1 — Thu, 04 Jun 2020 12:46:34 GMT

Hello everybody,

Qlik Senes is adding zeros to some of my imported values, I have an example below which shows the item_id. The item_id should only be 7 or 8 digits long. How can I prevent this?

The source is a csv file.

Thank you very much and br,

Oliver

Re: Qlik Sense is adding zeros to importet values

sunny_talwar — Thu, 04 Jun 2020 12:48:59 GMT

May be try loading it like this

Num(Replace(LTrim(Replace(item_id, '0', ' ')), ' ', '0')) as item_id

Re: Qlik Sense is adding zeros to importet values

Oliver1 — Thu, 04 Jun 2020 12:56:36 GMT

@sunny_talwar it's working, thank you!