topic Re: Numerics in QlikView

Numerics

nareshthavidishetty — Mon, 23 Nov 2015 06:47:01 GMT

Hi,

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

How to convert this into numeric.

Re: Numerics

prma7799 — Mon, 23 Nov 2015 06:52:17 GMT

Num(DeviceId,'##.#')

Re: Numerics

jonathandienst — Mon, 23 Nov 2015 06:52:30 GMT

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],

...

;

Re: Numerics

prma7799 — Mon, 23 Nov 2015 06:54:30 GMT

or please some sample data.

Re: Numerics

Anonymous — Mon, 23 Nov 2015 07:01:36 GMT

while loading try sth like

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

from

YourTable;

Re: Numerics

nareshthavidishetty — Mon, 23 Nov 2015 07:03:28 GMT

Hi,

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

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

Re: Numerics

Anonymous — Mon, 23 Nov 2015 07:07:15 GMT

try what I suggested..

Re: Numerics

PrashantSangle — Mon, 23 Nov 2015 07:10:34 GMT

Hi,

try with evaluate()

like evaluate(FieldName)

Regards

Re: Numerics

raghvendrasingh — Mon, 23 Nov 2015 07:10:51 GMT

Hi,

Can you please share some sample data.

Regards,

Raghvendra

Re: Numerics

nareshthavidishetty — Mon, 23 Nov 2015 07:13:05 GMT

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

Re: Numerics

tamilarasu — Mon, 23 Nov 2015 07:18:27 GMT

Hi,

Then try,

Num( Evaluate([Device Id]),'##.#') as [Device_ID]

Re: Numerics

Anonymous — Mon, 23 Nov 2015 07:27:08 GMT

how data type can be different when you are loading from a table?

Are you having multiple tables with same field and different data types??

Re: Numerics

qlikviewwizard — Mon, 23 Nov 2015 07:28:49 GMT

Hi Naresh,

What is your required output?

Re: Numerics

vipin_mishra479 — Mon, 23 Nov 2015 07:38:05 GMT

Hi,

Try to evaluate() function for this

may be this will help

vipin

Re: Numerics

nareshthavidishetty — Mon, 23 Nov 2015 08:37:46 GMT

not working

Re: Numerics

tamilarasu — Mon, 23 Nov 2015 08:41:02 GMT

Did you try the below one,

Num( Evaluate([Device Id]),'##.#') as [Device_ID]

Re: Numerics

jonathandienst — Mon, 23 Nov 2015 08:41:39 GMT

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

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

This must be the first load from the data source, which should have the number in normal number or text format without the exponent.

Re: Numerics

nareshthavidishetty — Mon, 23 Nov 2015 08:47:09 GMT

please go through with the below image,i need to show Like some ID's consists of numeric and some Id's consists of text

Re: Numerics

Chanty4u — Mon, 23 Nov 2015 09:16:45 GMT

use only

num(fieldname)

Re: Numerics

Chanty4u — Mon, 23 Nov 2015 09:18:07 GMT

Num(NUM#([device], '#'),'#.000') AS [deviceid]