Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My question is very simple - how to disable an automatic trim in script?
For example - when I have in my SQL table in two rows such data: "12345" and " 12345" (in second variant there is a space before the number) - all I have in Qlik in both rows - is "12345". Whether I use text(Field) or just a Field - any way Qlik trims spaces.
How to disable it?
There's a special variable for it, "Verbatim".
SET Verbatim = 1; // This stops the auto trim for anything following it in the script
SET Verbatim = 0; // This restarts the auto trim for anything following it in the script
There's a special variable for it, "Verbatim".
SET Verbatim = 1; // This stops the auto trim for anything following it in the script
SET Verbatim = 0; // This restarts the auto trim for anything following it in the script
thnx
it didn't work on my app
anythink else to check?