topic Re: Export To CSV in QlikView

Export To CSV

azmeerrehan — Tue, 17 Jul 2018 06:54:04 GMT

I have Employee ID like '0012345677' , it has leading zeroes in it. When I export it to Excel its fine but exporting as a CSV looses the leading 0's. I need the leading 0's when exporting to CSV. (QV 12))

Have already tried num(exployee ID, '0000000000')

Any suggestions

Re: Export To CSV

olivierrobin — Tue, 17 Jul 2018 07:06:35 GMT

hello

and what about using text() function ?

Re: Export To CSV

azmeerrehan — Tue, 17 Jul 2018 07:27:17 GMT

how does Txt function work

Re: Export To CSV

olivierrobin — Tue, 17 Jul 2018 07:32:23 GMT

Text() forces the expression to be treated as text, even if a numeric interpretation is possible.

Text (expr)

Re: Export To CSV

azmeerrehan — Tue, 17 Jul 2018 07:43:27 GMT

Doesnt work, still dropping out the leading 0's

Re: Export To CSV

Frank_Hartmann — Tue, 17 Jul 2018 07:54:34 GMT

this link might be helpful:

Keeping Leading Zero in Export

Re: Export To CSV

olivierrobin — Tue, 17 Jul 2018 07:57:24 GMT

try this

text(num(your column,'0000000'))

adjust the format according to your needs