Re: Numerics - Qlik Community

nareshthavidishetty · ‎2015-11-23

Hi,

I have created a table in that i am facing a problem below image is the reference.

How to convert this into numeric.

prma7799 · ‎2015-11-23

Num(DeviceId,'##.#')

jonathandienst · ‎2015-11-23

These are numeric. They are just too large to display as integers. As this is an ID according to your image, load them as text like this:

LOAD

...

Text([Device Id]) As [Device Id],

...

;

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

prma7799 · ‎2015-11-23

or please some sample data.

Anonymous · ‎2015-11-23

while loading try sth like

num(DeviceID,'#.##') as DeviceID

from

YourTable;

nareshthavidishetty · ‎2015-11-23

Hi,

Still i am getting the same out result after using the below field

Text([Device Id]) as [Device_ID],

Anonymous · ‎2015-11-23

try what I suggested..

PrashantSangle · ‎2015-11-23

Hi,

try with evaluate()

like evaluate(FieldName)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

raghvendrasingh · ‎2015-11-23

Hi,

Can you please share some sample data.

Regards,

Raghvendra

nareshthavidishetty · ‎2015-11-23

Hi Balraj,

Actually my device id contains both text and numerics.

Like some ID's consists of numeric and some Id's consists of text.

If i use the ' Num(([Device Id]),'##.#') as [Device_ID],' it show only integer ID's