Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.