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

[krishna20]

Hi Mahesh,

Can you try to change from listbox properties--> Number end.

Select Number format.

[qlikview979]

Hi All,

here i am sharing my mock up data.

[tamilarasu]

If I upload your excel in Qlikview 12.10, it automatically converts the ID field into number format. Sorry, I am not able to replicate the problem. Also, I have manually converted the ID field to text format (Text(ID) as ID) and tested few of the above suggested solutions and it's working fine.

[qlikview979]

Hi Nag,

Just,send it list box  to excel and check the format in excel how its showing.

[tresesco]

Check my reply here: Re: Text To Number

[tamilarasu]

Hi Mahesh,

Try this.