Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Spaces at the end of a string Dimension in QlikSense

Hello,

 

I would like to conditionally add a space after a dimension value in a table object, and to be able to maintain this space when exporting the table to Excel.

 

I have not faced any problem doing this in QlikView, but it seems that QlikSense is erasing the space when exporting the table to Excel. Or at least is not adding it in the object.

 

What I have done both in QV & QS:


1. Load two ID:

 

LOAD * INLINE [

ID_Space,

'E01922741',

'E01922742'];

2. Add the following expression as Dimension of a table object:

 

=if(ID_Space='E01922741',ID_Space&' ',ID_Space)

 

, and a count(ID_Space) as Expression and export it to Excel:

 

I have successfully exported the space after E01922741 ID in QV, but not in QS.

co1.png

co2.png

Does any of you faced this issue also? I would appreciate if you could provide me an alternative way to successfully add that space.

Thanks in advance!