In a Qlik Sense application - I need to create a pivot table where some of the values in Dimension DIM4 have preceding spaces.
It seems that the spaces "are there" but QS "hides" them. Any ideas how to manage it?
The same in QlikView - will work without any special issues.
Thanks in advance,
LOAD * INLINE [
DIM1, DimType, MEASURE1
My String, No Space, 100
My String, One leading space, 101
My String, Two leading spaces, 102
Next String, No Space, 103
Next String, One leading space, 104
Next String, Two leading spaces, 105
,Chr(39) & DIM1 AS DIM2
,Text(DIM1) AS DIM3
DROP TABLE Data20;
,If( DimType ='One leading space', ' '& DIM1
,If( DimType ='Two leading spaces', ' '& DIM1
)) AS DIM4
DROP TABLE Data19;
It seems you need to use non-breaking space chr(160) instead of chr(32) for your space:
Just test your app in different browsers to be certain they will show chr(160) in the way you wish.