Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am working in qlik sense and encounter a weird problem. Details below
The data coming from DB is like
test:
Load *inline
[text
6611
66 11
1166
];
Output in Qlik Sense
6611
1166
Qlik Sense somehow removed the spaces between the data. Just wanted to know why
Your valuable help or any previous experience with similar issue will be greatly appreciated.
Thanks,
Javed
Hi Javed,
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.
test:
Load text(text) as text_Revised inline [
text
6611
66 11
1166
];
Hope this helps to you
Thanks,
Deva
Thanks Devarasu!! This is Char field in Database. I have tried another scenario
test:
Load *inline
[text
6611
66 11
1166
2 3333 22 11
];
Output is below
It is not removing space by default. If you have a duplicate then this weird thing happen.. Please correct me if I have wrong assumption.
Hi,
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.
Regards,
Deva
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.
Spooky!!!
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,
Cheers
Luis