Discussion Board for collaboration related to QlikView App Development.
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
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.
In report Properties under Presentation tab.
Go for Alignment properties.
Is this did not work for you?
Hi navdeep
Maybe u can use that app found it some time ago. i hope it will help you.
/Teis
Hi,
Try using trim function in script to remove space from the concerned fields.
Have not tried , guess it should be working.
Hi ,
Please check the below attachment . Back ground color and text in expression and dimension
thanks ,
Bunny
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.
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
It's not what we want, spacing is required not color.
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.