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

Expression?

Hi!

I've got a Straight Table that looks something like this;

CustomerInvoiced valueAndel faktureratTBTB AndelTB%
Total3 000 00015%500 00016,6%
A1 000 0005%200 00015%5%
B1 000 0005%200 0005%
C500 0002,5%50 0003,3%
D500 0002,5%50 0003,3%

and what I want to do, is to divide the total Invoiced value with TB for each row. For example;



3 000 000/200 000 = TB Andel (=15) for Customer A.


Is it possible to do this in an Expression?


I hope you understand the weird explanation! Thank you!

6 Replies
srchilukoori
Specialist
Specialist

you can use

=column(1)/column(3)

as the expression for column(4), i.e., TD Andel

Anonymous
Not applicable
Author

try this

 

=sum(TB)/sum(total Invoiced value)

its_anandrjs

You can write

=Sum( ALL  [Invoiced Value]) / Sum(TB)



for each row in the table



cfz
Former Employee
Former Employee

Hi Jonathan,

Try

sum(TB)/(sum(TOTAL [Invoiced value])

This should solve the problem.

Regards

Carlos

its_anandrjs

You can also write it different ways also for TB Andel like

=(sum(ALL [Invoiced value]) / sum(TB)) & '%'

Not applicable
Author

sum(ALL [Invoiced value]) / sum(TB)