Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Indentation in straight table

Hi,

We have to add spaces in front of dimension to indent it in a report format in straight table, we have tried '  ' and char(32) but it's removing spaces on access point. Please suggest some solution.

Ex:-

Travel                                    21

    Travel Local                      15

    Travel International           16

Expense                                21            

Regards,

Navdeep

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

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

15 Replies
Anonymous
Not applicable
Author

In  report Properties under Presentation tab.

Go for Alignment properties.

Is this did not work for you?

teiswamsler
Partner - Creator III
Partner - Creator III

Hi navdeep

Maybe u can use that app found it some time ago. i hope it will help you.

Return Caracter

/Teis

Not applicable
Author

Hi,

Try using trim function in script to remove space from the concerned fields.


Have not  tried , guess it should be working.

Anonymous
Not applicable
Author

Hi  ,

Please check the below attachment . Back ground color and text in expression and dimension

thanks ,

Bunny

Not applicable
Author

Balraj,

That is only for left, right and center alignment, we have total 8 different levels for indentation. I guess we will have to do something in dimension, but space is not showing up on access point/web view.

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi Navdeep,

I was wondering, Why don't you do a pivot table like this?

Sem Título.png

I think that a pivot table should surfice you problem.

Miguel

Not applicable
Author

It's not what we want, spacing is required not color.

Not applicable
Author

Hi Braga,

We can't use pivot table, it has to look like a report, both higher level i.e Travel and lower level Travel Local, Travel International has to be in same column.

Anonymous
Not applicable
Author