topic Formatting in QlikView

Formatting

Anonymous — Tue, 17 Jan 2017 13:26:47 GMT

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 — Tue, 17 Jan 2017 13:42:16 GMT

why not?

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

Anonymous — Tue, 17 Jan 2017 13:47:09 GMT

No sorry its not working, I tried every format!

can I update my script somewhere ?

Thank you

girirajsinh — Tue, 17 Jan 2017 13:55:41 GMT

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 — Tue, 17 Jan 2017 14:11:17 GMT

if your decimal operator is comma

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

Anonymous — Tue, 17 Jan 2017 14:19:43 GMT

So maybe its easier to understand now

sunny_talwar — Tue, 17 Jan 2017 14:31:55 GMT

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 — Tue, 17 Jan 2017 14:41:58 GMT

saved me