Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
By using num function
May be as below:
=Num#(412995)
OR
=Num#(412995, '#.#', '.' , ',')
Not working,its showing same format with green color
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.
Are you looking this in qlikview or excel?
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.
Hi,
1 option:
=num(KeepChar(field,'0123456789'),'#.##0')
Hi Fer,
Its not working.
Settings -> Document Properties-> Number -> Select the expected field & number format.