Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dmpilars
Partner
Partner

HOW TO IGNORE TRIM FUNCTION?

Hi people ,

I have a problem with a CrossTable, I need to Ignore a Trim function, that happened when I use the CrossTable function.

I have this value in Excel: (                     AAAAAA)  but when I use the CrossTable function, the Qlik result table value is (AAAAAA) without any spaces. I need the exactly value that Excel, with spaces.


Please Help Me!!!!


Thanks

1 Solution

Accepted Solutions
sunny_talwar

Should work the same way in Qlik Sense

Verbatim ‒ Qlik Sense

View solution in original post

4 Replies
sunny_talwar

Look here

Verbatim ‒ QlikView

SET Verbatim = 1;

or may be

SET Verbatim = 0;

dmpilars
Partner
Partner

Thank you for your answer. I need to put this in the Main? I work whit Qlik Sense

sunny_talwar

Should work the same way in Qlik Sense

Verbatim ‒ Qlik Sense

View solution in original post

dmpilars
Partner
Partner

Thank you!!!!!! Perfect