topic Re: List box Data from text to number in QlikView

List box Data from text to number

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: List box Data from text to number

qlikview979 — Mon, 04 Dec 2017 16:42:18 GMT

By using num function

Re: List box Data from text to number

trdandamudi — Mon, 04 Dec 2017 16:46:25 GMT

May be as below:

=Num#(412995)

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

Re: List box Data from text to number

qlikview979 — Mon, 04 Dec 2017 16:48:48 GMT

Not working,its showing same format with green color

Re: List box Data from text to number

trdandamudi — Mon, 04 Dec 2017 16:57:22 GMT

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.

Re: List box Data from text to number

vishsaggi — Mon, 04 Dec 2017 17:00:44 GMT

Are you looking this in qlikview or excel?

Re: List box Data from text to number

qlikview979 — Mon, 04 Dec 2017 17:08:28 GMT

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.

Re: List box Data from text to number

el_aprendiz111 — Mon, 04 Dec 2017 17:20:50 GMT

Hi,

1 option:

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

Re: List box Data from text to number

qlikview979 — Tue, 05 Dec 2017 07:02:35 GMT

Hi Fer,

Its not working.

Re: List box Data from text to number

pooja_sn — Tue, 05 Dec 2017 07:05:52 GMT

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

Re: List box Data from text to number

srishsum2017 — Tue, 05 Dec 2017 07:08:59 GMT

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

Re: List box Data from text to number

qlikview979 — Tue, 05 Dec 2017 07:12:59 GMT

I am using that column as like dimension

Re: List box Data from text to number

qlikview979 — Tue, 05 Dec 2017 07:14:02 GMT

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

Re: List box Data from text to number

srishsum2017 — Tue, 05 Dec 2017 07:19:18 GMT

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

num#(fieldname,'##')

Re: List box Data from text to number

Anonymous — Tue, 05 Dec 2017 07:20:39 GMT

try this...

num(num#(Fieldname))

Re: List box Data from text to number

krishna20 — Tue, 05 Dec 2017 07:22:26 GMT

Hi Mahesh Kumar,

Please try like below

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

Re: List box Data from text to number

qlikview979 — Tue, 05 Dec 2017 07:24:09 GMT

Thanks for your help,

but its not working in front end level

Re: List box Data from text to number

qlikview979 — Tue, 05 Dec 2017 07:25:59 GMT

Kalyan & John

Its not working.

Re: List box Data from text to number

Anonymous — Tue, 05 Dec 2017 07:31:18 GMT

Mahesh cud u pls attach ur file with sample data

Re: List box Data from text to number

tamilarasu — Tue, 05 Dec 2017 07:32:15 GMT

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.