Number conversion

[nareshthavidishetty]

Hi,

We have used excel as an data source in that Device id is an dimension.

When we imported the data in qlikview the device id is came out as below.

How convert the same into numeric in qlikview.

Thanks..

[sunny_talwar · Accepted solution]

May be like this:

Num([Device ID], '##.####') as [Device ID]

[Chanty4u]

Num([Device ID)/10000, '##.00')

[Chanty4u]

or else u can change the  format in  Number tab