Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

qlikview979
Valued Contributor

List box Data from text to number

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

Num format.PNG

25 Replies
qlikview979
Valued Contributor

Re: List box Data from text to number

By using num function

trdandamudi
Honored Contributor

Re: List box Data from text to number

May be as below:

=Num#(412995)

OR

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

qlikview979
Valued Contributor

Re: List box Data from text to number

Not working,its showing same format with green color

trdandamudi
Honored Contributor

Re: List box Data from text to number

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
Esteemed Contributor III

Re: List box Data from text to number

Are you looking this in qlikview or excel?

qlikview979
Valued Contributor

Re: List box Data from text to number

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
Valued Contributor

Re: List box Data from text to number

Hi,

1 option:

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

qlikview979
Valued Contributor

Re: List box Data from text to number

Hi Fer,

Its not working.

Highlighted
pooja_sn
Contributor

Re: List box Data from text to number

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