Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

How to Change Text Format to number Format

Hi All,

I have a requirement. i want to change text format to number format.. Here i am attaching Excel and qvw. all are changing from text to number format except one..1,182,201.00  Please Help me..

9 Replies
sureshqv
Esteemed Contributor III

Re: How to Change Text  Format to number Format

try

=Num(urfield)

trdandamudi
Honored Contributor

Re: How to Change Text Format to number Format

Use Num() function...

mwoolf
Honored Contributor II

Re: How to Change Text Format to number Format

Your Excel data says: 1,82,201.00

panipat1990
Contributor II

Re: How to Change Text  Format to number Format

i already used num(ABC) function but result not found.

MVP
MVP

Re: How to Change Text Format to number Format

Try this:

Tab:

Load

  ABC,

  Num(Num#(ABC, '##,##,##,##,##,##0.00'), '##,##,##,##,##,##0.00')  As ABC1

From

[LB07_20160516_141128.xls]

(biff, embedded labels, table is Sheet1$);


Capture.PNG

alexpanjhc
Valued Contributor

Re: How to Change Text Format to number Format

You do not have 1,182,201.00 at all in your excel. You have two 182,201.00 one is formatted as is, the other is formatted as  1,82,201.00

panipat1990
Contributor II

Re: How to Change Text Format to number Format

Hi Sunny,

When i select 182,201.0,From ABC List Box... Then It show 1,82,201.00 In ABC1 List Box..

MVP
MVP

Re: How to Change Text Format to number Format

What do you want it to show?

hirishv7
Honored Contributor

Re: How to Change Text Format to number Format

Hi,

Check this,

Num(PurgeChar(ABC,','),'##,##,##,##,##,##0.0') As ABC1

HTH,

Hirish