Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Thanks Marco. Just want tom know what is the output of using '(dec)'
Be careful about this
"Note that while using Evaluate() returns a number, it is only stored with 14 digit precision. While you may be able to see more than 14 digits, this is just the formatting. The internal mantissa is only 14 digits."