Number formatting

[#1]

Another easy question: I have a file with numbers in the format "01" but when uploaded to Qlikview it changes this to "1".  How do I make it retain the "01" format?

[maxgro]

in load use

text(yourfield)

[its_anandrjs]

Update sorry i misplace the Text function now you can check

Write like

Load

Num(YourField,'000') as Yourfield1  //if you want to make it 001

Num(YourField,'00') as Yourfield2  //if you want to make it 01

From Location;

OR

Load

Text(YourField) as Yourfield1

From Location;

[IAMDV]

Hi John,

I'd recommend using Text() and Dual() function. This way you can keep the text formatting and also perform aggregation as a number field.

See the attached example.

I hope this helps!

Cheers,

DV

www.QlikShare.com

[MK_QSL]

Use below in script...

Num(YourFieldName,'00') as YourFieldName;

[Joseph_Musekura]

Hi,

Please read attached documentation. It explains why and how to avoid this issue

[IAMDV]

Thanks Joseph. Good to get insight from QlikTech.

Cheers,

DV