Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist

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
Specialist
Specialist
Author

By using num function

trdandamudi
Master II
Master II

May be as below:

=Num#(412995)

OR

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

qlikview979
Specialist
Specialist
Author

Not working,its showing same format with green color

trdandamudi
Master II
Master II

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
Champion III
Champion III

Are you looking this in qlikview or excel?

qlikview979
Specialist
Specialist
Author

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
Specialist
Specialist

Hi,

1 option:

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

qlikview979
Specialist
Specialist
Author

Hi Fer,

Its not working.

pooja_sn
Creator
Creator

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