Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Cant Load Excel File because of hidden character


I have problem. I need to load Sales target excel files. The name of the files is identical except for the month and year - 

"Sales Target MM YYYY.xls".

Now, I load the files like this: "Sales Target*.xls". We found out that some of the file weren't loaded. After some searching we found out that in those files there is a special character (Right to left) that you can't see but the Qlik does.

Since Hebrew is right to left we tried all sort of solution (Keyboard direction when typing the file name and so forth) but it is not consistent.

We don't know what caused it'how to save the file without it and how to make the Qlik ignore it (without the obvious solution of "*Sales Target*.xls".

We Use QlikSense April 2019, I've attached an example.




0 Replies