List box Data from text to number

[qlikview979]

Hi all,

My list box data is showing  text format ,but i want to change from text to number format in front end level.how can i do it

Regards

Mahesh

[qlikview979]

By using num function

[trdandamudi]

May be as below:

=Num#(412995)

OR

=Num#(412995, '#.#', '.' , ',') 

[qlikview979]

Not working,its showing same format with green color

[trdandamudi]

In your load statement, use the following statement and see if it works:

Num( EVALUATE(Your Field Here),'#0') As Newfield

Note: Replace "Your Field Here" with your field name.

[vishsaggi]

Are you looking this in qlikview or excel?

[qlikview979]

Is there any possibility to change in Front end level. in app having 30+ sheets  and  if i go for reload i have to change all sheets paths.this is existing app some one developed.

[el_aprendiz111]

Hi,

1 option:

=num(KeepChar(field,'0123456789'),'#.##0')

[qlikview979]

Hi Fer,

Its not working.

[pooja_sn]

Settings -> Document Properties-> Number -> Select the expected field & number format.