Text to Number Formatting Issue

[qliksus]

Hi,

I have loaded data from excel joined with inline data, but excel data considered as Number where as Inline data considered inside Qlikview as Text which doesn't create proper link.

Pls find the attached JPEG file where you can see Excel data is in number and Inline is in Text where as both case numbers are same in both cases.

Can anyone help me to solve this?

[Clever_Anjos]

Probably you are outpassing maximum number in QlikView.

Please treat all records as text using text#()

[Anonymous]

Try this:

num(Num,'#,##0')

[qliksus]

Hi Michael,

Thanks for the reply, but above thing won't work.

Regards,

Susant

[Anonymous]

Apparently as cleveranjos‌ says, you've exceeded Qlik's precision limit.

[MarcoWedel]

Hi,

one possible solution could be:

LOAD *,
    If(IsNum(Inline),Inline,Right(Inline,14)+Left(Inline,Len(Inline)-14)*1E14) as Inline2,
    If(IsNum(Inline),Inline,Num(Right(Inline,14)+Left(Inline,Len(Inline)-14)*1E14,'(dec)')) as Inline3
Inline [
Inline
9
98
982
9826
98261
982617
9826170
98261706
982617063
9826170633
98261706330
982617063302
9826170633029
98261706330294
99999999999999
100000000000000
982617063302940
982617063302941
982617063302942
982617063302943
982617063302944
982617063302945
982617063302946
982617063302947
982617063302948
982617063302949
982617063302950
982617063402934
982617063402940
];

hope this helps

regards

Marco

[PrashantSangle]

Hi,

Take look at evaluate()

Read below blog

https://community.qlik.com/blogs/qlikviewdesignblog/2015/01/30/evaluate-function

It might help you.

Regards

[qliksus]

Hi Max dreamer,

Thanks for the reply. It worked

[qliksus]

Hi Marco,

Thanks for the reply. Can i get the script written for Inline-3 as some portionn is cutting -off in the above comments.

[MarcoWedel]

Hi,

If(IsNum(Inline),Inline,Num(Right(Inline,14)+Left(Inline,Len(Inline)-14)*1E14,'(dec)')) as Inline3

hope this helps, although I think Max found the easier solution.

regards

Marco