Qlik keeps formatting numbers based on first match

[p_verkooijen]

Got a MSSQL database with numbers formatted with or without a prefix 0

QlikView May 2022SR2 formats the numbers based on sort order. First row is the winner..

Qlik Script:

Output

LEN en TEXT display's the difference in LEN and content

Order by ID ASC all EANcode's become 0850010131146

Order by ID DESC all EANcode's become 850010131146

[p_verkooijen]

Hi @ElisaF ,

Thank you for the example, I will check if this works for me

[ElisaF]

Thanks for the reply. I look forward to your feedback. I am curious if the solution solved your issue.