Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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%')))
why not?
num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'##,#%')
No sorry its not working, I tried every format!
can I update my script somewhere ?
Thank you
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
if your decimal operator is comma
use num((sum( VSP_Gesamt))/(sum(Umsatz_Gesamt )),'##,#%',',')
I
So maybe its easier to understand now
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%')))
saved me