Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
chaitanya_muthaiya1
Contributor
Contributor

Section Access

Hidden characters in Excel file after loading them for section access. Because of which we cannot apply the section access changes to the users.

Labels (1)
2 Replies
rajjul
Partner - Contributor III
Partner - Contributor III

Try this while loading an Excel file or field, So it allows only Alphabet and numeric char only.

KeepChar(FieldName, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVQXYZ 1234567890') as  FieldName

MayilVahanan

HI

Hidden characters means, i think, its contains empty space..

In that case, try with trim() function, else, you can use @rajjul suggestion.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.