topic Re: Re: Re: Text Format(Number To Number Format in QlikView

Text Format(Number To Number Format

aveeeeeee7en — Sun, 06 Jul 2014 13:03:07 GMT

Hi Community

I am not able to convert Text Format(Number To Number Format

Kindly see the Attachment.

Regards

Aviral Nag

Re: Text Format(Number To Number Format

its_anandrjs — Sun, 06 Jul 2014 13:34:56 GMT

Try Num function like

LOAD

NUM([Amount in local cur.]) as [New Num Field]

From Location;

Re: Re: Text Format(Number To Number Format

aveeeeeee7en — Sun, 06 Jul 2014 13:37:53 GMT

Thanks for the Reply.

If it's that easy to crack than i would done this earlier.

NUM([Amount in local cur.]) Not working.

The data is some Text & some Number.

Sir, See the Attachment

Re: Re: Re: Text Format(Number To Number Format

Anonymous — Sun, 06 Jul 2014 14:39:29 GMT

Nag

I think it is as easy as to just do what anand chouhan suggested.

Tab :

LOAD

num( [Amount in local cur.] )

FROM

[Num Problem.xlsx]

(ooxml, embedded labels, table is [April 2014 again]);

I have tested it against your *.xlsx using the script above and it works perfectly. What kind of 'Not working' do you encounter ?

Best Regards, Bill

Re: Text Format(Number To Number Format

MK_QSL — Sun, 06 Jul 2014 14:52:33 GMT

Use Evaluate function...

Re: Text Format(Number To Number Format

aveeeeeee7en — Sun, 06 Jul 2014 16:15:18 GMT

Total Records = 11426

When using num() function, i am getting 8221 Records

I want all 11426 to be in Number Format.

Re: Text Format(Number To Number Format

Anonymous — Sun, 06 Jul 2014 16:35:59 GMT

I think I can see the joker, as in the large numbers have commas for lakh & crore as opposed to thousands and millions. Removing the commas with purgechar() sorts this.

num( purgechar ([Amount in local cur.] , ',' ) ) as NN ,

Re: Text Format(Number To Number Format

aveeeeeee7en — Sun, 06 Jul 2014 17:43:30 GMT

Thank You Bill Sir.

Sir I have tried with '1E100' for large numbers bu had no Luck with it.

I also like to to thank others who gave suggestions and their valuable time.