Space in Qliksense

[fkeuroglian]

Hi Expert

I have a situation:

I have information from one table that contain space in blank(in some cases) but i want to do the same in my pivot table in qliksense and i cant

Qliksense for defect do a like a trim function and delete all the trim that some value contain in the database

for example:

i attached two image, that show how i see in the database and how i see in qliksense, is there any way to create this blanks space?

Thank a lot?

Fernando K.

[rupamjyotidas]

From the help:

Verbatim

Normally all field values are automatically stripped of preceding and succeeding blank characters (ASCII 32) before being loaded into the QlikView database. Setting this variable to 1 suspends the stripping of blank characters.

Example:

set Verbatim = 1;

Might Help you

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/SystemVariables/Verbatim.htm