Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Formatting

My dear Qlikview community,

I have another question:

fehler.PNG

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

1 Solution

Accepted Solutions
sunny_talwar

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%')))

View solution in original post

7 Replies
girirajsinh
Creator III
Creator III

why not?

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

Anonymous
Not applicable
Author

No sorry its not working, I tried every format!

can I update my script somewhere ?

Thank you

girirajsinh
Creator III
Creator III

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
Creator III
Creator III

if your decimal operator is comma

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

I

Anonymous
Not applicable
Author

So maybe its easier to understand now

sunny_talwar

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
Not applicable
Author

saved me