Because it's number field, by default while load these data it will remove the space from that number field. to prevent u can use Text function.
Load text(text) as text_Revised inline [
Hope this helps to you
auto Trim.qvf 192.0 K
yes. qlikview/sense will return distinct unique vale in chart object (prompt, table, chart etc) because it's number. first it will auto trim and then it will show the distinct value in your chart object.
P.S: if you wish to retain the same string in qlik then u have to use the text / keepchar / other string function.
hope it's clear, close this thread by marking as helpful and correct.
Thanks for sharing this Javed, I never noticed it.
I ran other tests coming from an excel file as well and this is the conclusion I'm getting:
It seems to depend on the load order: whatever you load first, then the rest that's similar will follow the "template" provide by the first... and it seems to work both ways from number to text and from text to number
First 11 22 and then 1122 will produce 2 records with 11 22
First 1 2 3 4 5 6 and then 123456 will produce 2 records with 1 2 3 4 5 6
First 1122 and then 1 1 2 2 will produce 2 records with 1122
First 123456 and then 123 4 56 will produce 2 records with 123456
Even coming from different loads, one from an inline for example and the second load from an excel file for the same qlik sense table.
I tried to find any information about on the Help but couldn't. I hope other community members would see this and share their thoughts
Thanks again Javed,