0 Replies Latest reply: Jun 8, 2016 5:58 AM by Carme Fernández RSS

    Spaces at the end of a string Dimension in QlikSense

    Carme Fernández

      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!