Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fkeuroglian
Partner - Master
Partner - Master

Column in sense

Hi Expert

I have this dimension in a qlikview report, and i want to do the same in qlik, i want to know if there are any way to simulate this

attached image with the dimension in qlik, and the result in sense.

as you can see in qliksense there are a hirechachy in the sctructure, but in sense align all to the left and lost the structure

see the attached.

Thanks a lot

Fernando K.

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Qlik Sense uses HTML rendering, and in that standard leading spaces are removed in the display. To preserve the leading spaces in the display, replace them with chr(160) characters.

For example. in your load:

replace( Nombre,' ',chr(160)) as Nombre

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

fkeuroglian
Partner - Master
Partner - Master
Author

Hi Rob, how are you? thanks for your answer

but i cant do it, persist the same problem with the column

see this attached

thank you Rob

Fernando K.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

There are no leading spaces in the input "Nombre" in the sample you supplied.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

fkeuroglian
Partner - Master
Partner - Master
Author

Hi rob thanks for your comment

Attached the good version

QVF

QVD

QVW to compare with sense

thanks a lot again for your time!