Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
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
Highlighted
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

15 Replies
Highlighted
balrajahlawat
Esteemed Contributor

Re: Indentation in straight table

In  report Properties under Presentation tab.

Go for Alignment properties.

Is this did not work for you?

Highlighted
Partner
Partner

Re: Indentation in straight table

Hi navdeep

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

Return Caracter

/Teis

Highlighted
Not applicable

Re: Indentation in straight table

Hi,

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


Have not  tried , guess it should be working.

Highlighted
bunnyv123
Contributor II

Re: Indentation in straight table

Hi  ,

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

thanks ,

Bunny

Highlighted
Not applicable

Re: Indentation in straight table

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.

Highlighted
miguelbraga
Valued Contributor III

Re: Indentation in straight table

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

Highlighted
Not applicable

Re: Indentation in straight table

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

Highlighted
Not applicable

Re: Indentation in straight table

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.

Highlighted
balrajahlawat
Esteemed Contributor

Re: Indentation in straight table