Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: Indentation in straight table

You should be able to add spaces in a straight/pivot table for example. In the dimensions tab add a calculated dimension and add '    ' & Dimension name. Works with if-statements as well, if you only want to indent some of the dimension values in your chart.

Should also work to do in the script like this:

Test:

Load

   '    ' & Dim1 as Dim2

resident data;

MVP
MVP

Re: Indentation in straight table

Chr(160) usually works where Chr(32) doesn't.  Chr(160) is so called non-break space. If that fails there is a second option using Unicode space characters like Chr(8192) - a typographic space character.

View solution in original post

Not applicable

Re: Indentation in straight table

chr(160) worked, thanks

bunnyv123
Contributor II

Re: Indentation in straight table

Hi ,

i think,

SubField(Chr(160),Travel ) as Travel1

Regards,

Bunny

jldengra
Contributor

Re: Indentation in straight table

Sometimes repeating the character ' ' is not enough to add spaces at the left for indentation because they are trimmed and ignored. In those cases, my workaround has been to repeat the tab character Chr(9) instead of ' ' to get the desired indentation.

Highlighted
taylor_jesse
Contributor

Re: Indentation in straight table

Hi,

After indenting a column can you include the column name in an expression? I tried using the chr(160) &''&Name in an expression and it didn't work