topic Re: Number format pattern for accounting in QlikView

Number format pattern for accounting

Thu, 26 Feb 2015 08:47:08 GMT

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

Re: Number format pattern for accounting

tresB — Thu, 26 Feb 2015 08:53:40 GMT

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

Re: Number format pattern for accounting

jonathandienst — Thu, 26 Feb 2015 08:54:50 GMT

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

Re: Number format pattern for accounting

Thu, 26 Feb 2015 08:55:37 GMT

Hi treseco,

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

The report needs to look clean. not jumping currency signs

Re: Number format pattern for accounting

Thu, 26 Feb 2015 08:57:07 GMT

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

Re: Number format pattern for accounting

marcus_sommer — Thu, 26 Feb 2015 09:03:41 GMT

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

Re: Number format pattern for accounting

Thu, 26 Feb 2015 09:46:41 GMT

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.