is there any function of space in qlikview?

[SunilChauhan]

hi all,

i want to function line Chr(4) so that i will add space according to need in a column.

My data is showing like this

Branch count amount

lucknow 66 234

Ahemdabad 56 490

bhopal 34 45

but i want like

Branch count amount

lucknow 66 234

Ahemdabad 56 490

bhopal 34 45

it seems chr function is not a suitable option

[Miguel_Angel_Baeyens]

Hello Tom,

I'm afraid I'm missing your point, but you can add some spaces to any expression using

=Repeat(' ', 10)

Hope that helps

[SunilChauhan]

hi Miguel,

thanks for kind reply.but i again have some problem.

i am using this expession. but its not giving right input.

sunil

[SunilChauhan]

hi Miguel,

thanks for kind reply.but i again have some problem.

i am using this expession. but its not giving right input.

if

(len(BRANCH)<14,upper(BRANCH) &''& Repeat(' ',14-len(BRANCH)),BRANCH

)

sunil

[Anonymous]

Try using tab, chr(09). Apparently you need to check the length as well, and add more than one tab if needed.

[#6]

You might get the output to look the way you want if you change the Font of the text in the column. Use a font where all of the characters are the same width like Courier or Lucida Console.

[shaan007]

Alternative Option:

Instead of using text box and Tabs,

use straight table.

Add your fields as Expressions , leave the Dimension Empty.

remove total and in presentation Tab tick Horizontal.

you can adjust the column width and it looks tidy.

in General Tab, make that as Read Only.