Formatting

[Anonymous]

My dear Qlikview community,

I have another question:

I want to see absolut numbers as well as percentage in one table.

Its working but it always puts a 0 infront of the percent!

Could you maybe help me?

Thats the skript:

= num(sum ([AE_Gesamt]), '#.##0')

&

num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'0,#%')

Thank you & Greetings

Tina

[girirajsinh]

why not?

num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'##,#%')

[Anonymous]

No sorry its not working, I tried every format!

can I update my script somewhere ?

Thank you

[girirajsinh]

so what is your decimal separator ? '.' or ','

what this gives ? num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'##.#%')

You can try formatting in Number tab in object properties

[girirajsinh]

if your decimal operator is comma

use num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'##,#%',',')

I

[Anonymous]

So maybe its easier to understand now

[sunny_talwar · Accepted solution]

Try this:

=If(Titel='Auftragseingang',

  Num(Sum({<cat={'VJ MS'}>} [AE_Gesamt]), '#.##0'),

If(Titel='VSP in %',

  Num(Sum({<cat = {'VJ MS'}>} VSP_Gesamt)/Sum({<cat = {'VJ MS'}>} Umsatz_Gesamt),'#,0%')))

[Anonymous]

saved me