HOW TO IGNORE TRIM FUNCTION?

[dmpilars]

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

[sunny_talwar]

Look here

Verbatim ‒ QlikView‌

SET Verbatim = 1;

or may be

SET Verbatim = 0;

[dmpilars]

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

[sunny_talwar · Accepted solution]

Should work the same way in Qlik Sense

Verbatim ‒ Qlik Sense

[dmpilars]

Thank you!!!!!! Perfect