topic Re: Re: Number formatting in QlikView

Number formatting

Thu, 01 May 2014 16:04:57 GMT

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?

Re: Number formatting

maxgro — Thu, 01 May 2014 16:06:13 GMT

in load use

text(yourfield)

Re: Number formatting

its_anandrjs — Thu, 01 May 2014 16:10:48 GMT

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;

Load

Text(YourField) as Yourfield1

From Location;

Re: Number formatting

IAMDV — Thu, 01 May 2014 17:31:49 GMT

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,

www.QlikShare.com

Re: Number formatting

MK_QSL — Thu, 01 May 2014 18:24:30 GMT

Use below in script...

Num(YourFieldName,'00') as YourFieldName;

Re: Number formatting

Joseph_Musekura — Thu, 01 May 2014 20:22:07 GMT

Hi,

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

Re: Re: Number formatting

IAMDV — Thu, 01 May 2014 20:24:57 GMT

Thanks Joseph. Good to get insight from QlikTech.

Cheers,