Number format pattern for accounting

[#1]

Hello,

Is it possible to make a number format pattern to make my table in qlikview look like this?

I tried to do it with Tab and spaces but it will just look wrong

thanks for your help

[tresB]

In the number tab, take money format and put spaces like:

[jonathandienst · Accepted solution]

Hi

I don't think that is possible. Aligning with spaces will only work with a monospaced font (like Courier New or one of the Console fonts).

What you could do is create an expression ='€' and a blank label to display the currency symbol in a column.

HTH

Jonathan

[#4]

Hi treseco,

i tried that first but it will not be alligned nicely.

The report needs to look clean. not jumping currency signs

[#5]

Hi,

Just contacted my Qlik Trainer, needed answer fairly quick.

Indeed as Jonathan mentions it is not possible. the best solution is to create expression with currency symbol.

thanks for your reply

[marcus_sommer]

I would prefer a solution like jonathan dienst suggested - it's clear and wasted not space. But if you really want such format you could use a format-function like: num(144186.07, '€     #.##0,00') with a monospaced font or with more effort count the len from your numbers and create with repeat your needed count of space-chars. But you won't reach a pixel-perfect look if you don't used a monospace font - it's only nearby ...

- Marcus

[#7]

Yes, this is the solution i used in the end and the client was happy with the result so thank you all for the help.