Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
May be like this:
Num([Device ID], '##.####') as [Device ID]
Num([Device ID)/10000, '##.00')
or else u can change the format in Number tab