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

[srishsum2017]

use num# function at the backend from where this field has been come in your data

[qlikview979]

I am using that column as like dimension

[qlikview979]

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

I need in front end level and i am using this column  dimension

[srishsum2017]

Open list box properties-----choose expression in field-----and write----

num#(fieldname,'##')

[Anonymous]

try this...

num(num#(Fieldname)) 

[krishna20]

Hi Mahesh Kumar,

Please try like below

Num#(Field_name,'###,###',',','.')

[qlikview979]

Thanks for your help,

but its not working in front end level

[qlikview979]

Kalyan & John

Its not working.

[Anonymous]

Mahesh cud u pls attach ur file with sample data

[tamilarasu]

Hi Mahesh,

Instead of saying it's not working, why can't you upload a sample file. It will be helpful for us to provide the solution easily. If not, it's just a guess game.