How can we display this in qlikvew

[#1]

hi all,

i have field in script as code and

i have loaded excel file containing field as code.

but data is not matching because in excel file code data like('0170','0012')

but in script data is loading for code like('170','12')

how can i chnage in script to get ('0170','0012') ??

please tell me the expression  i have to use?

[jerem1234]

Try using:

Text(ID) as ID

where ID would be your field.

Hope this helps!

[ashfaq_haseeb]

Hi use Text(your Field) as Field.

Regards

ASHFAQ

[MK_QSL]

if you want to keep your field as number only, you can use as below

NUM(DATA,'0000') as DATA

Where DATA is your Fieldname

[#5]

it is not working i need to add zero's before if data contains less than 4 digits.

[#6]

it is not working i need to add zero's before if data contains less than 4 digits.

[ashfaq_haseeb]

Hi,

Try below

NUM(Field,'0000') as Field

Or

Repeat('0',4(Field))&Right(Field,4)

Regards

ASHFAQ