Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 [
2. Add the following expression as Dimension of a table object:
, 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.
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!
Looking to a way to remonve ( and not add) a space at yhe end of a string , I found your post
It does not help me but
In Qlik Sense
do like this
it may woks fine
chr(32) is the unicode for space