topic Re: Indentation in straight table in QlikView

Indentation in straight table

Wed, 14 Oct 2015 08:20:19 GMT

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

Re: Indentation in straight table

Anonymous — Wed, 14 Oct 2015 08:25:26 GMT

In report Properties under Presentation tab.

Go for Alignment properties.

Is this did not work for you?

Re: Indentation in straight table

teiswamsler — Wed, 14 Oct 2015 08:27:40 GMT

Hi navdeep

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

Return Caracter

/Teis

Re: Indentation in straight table

Wed, 14 Oct 2015 08:28:23 GMT

Hi,

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

Have not tried , guess it should be working.

Re: Indentation in straight table

Anonymous — Wed, 14 Oct 2015 08:29:03 GMT

Hi ,

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

thanks ,

Bunny

Re: Indentation in straight table

Wed, 14 Oct 2015 08:30:01 GMT

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.

Re: Indentation in straight table

miguelbraga — Wed, 14 Oct 2015 08:31:08 GMT

Hi Navdeep,

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

I think that a pivot table should surfice you problem.

Miguel

Re: Indentation in straight table

Wed, 14 Oct 2015 08:33:35 GMT

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

Re: Indentation in straight table

Wed, 14 Oct 2015 08:35:06 GMT

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.

Re: Indentation in straight table

Anonymous — Wed, 14 Oct 2015 08:35:12 GMT

Check these threads.

Indent Mode does not display higher dimensions properly when collapsed

Indenting Space in Cell

Re: Indentation in straight table

Wed, 14 Oct 2015 08:36:08 GMT

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;

Re: Indentation in straight table

petter — Wed, 14 Oct 2015 08:37:22 GMT

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.

Re: Indentation in straight table

Wed, 14 Oct 2015 08:45:28 GMT

chr(160) worked, thanks

Re: Indentation in straight table

Anonymous — Wed, 14 Oct 2015 08:53:23 GMT

Hi ,

i think,

SubField(Chr(160),Travel ) as Travel1

Regards,

Bunny

Re: Indentation in straight table

jldengra — Tue, 31 May 2016 07:20:53 GMT

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.

Re: Indentation in straight table

taylor_jesse — Thu, 26 Jul 2018 13:46:09 GMT

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