topic please help me !!!!!!!! in QlikView

please help me !!!!!!!!

Thu, 05 Nov 2009 21:55:48 GMT

Dear All,
I need help for this problem.

in customer code field I have a code build by 00 before a number
for example:
001234
Total 6 digits.

Now I have sent to excel and I reloaded the data but the
customerCode lost the
double '00' :
now the code 001234 is 1234 and so it doesn't link a customer name.

please note the customer loaded from database works but the customer from wxcel doesn't work correctly.
the customer is formed by 2 rows:

CustomerCode | Customer name
001234 | AAA
1234 -

How fix it . Please I have a Budget pending 😞

thanks

Best Regards,
Slash

please help me !!!!!!!!

hector — Thu, 05 Nov 2009 22:05:03 GMT

hi, have you tried text() function? or in your case maybe the num function will work too. If you use num, use this way num(field,'000000')

rgds

please help me !!!!!!!!

Thu, 05 Nov 2009 22:13:48 GMT

Hi,

see the example (script) and function Num.

Good luck!

Rainer