Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

divide by expression

Hi guys,

I want to divide som values but I cant find the correct expression .

I have a table witch some coloms

sum(a)

4471

sum(b)

5572

sum(c)

925

I want to make an expression

sum(a)/(sum(b)-sum(c))    

4471/(5572-925)  =0,926

but i Qlikview outcome 0,73

Thanks in advance

5 Replies
dmohanty
Partner - Specialist
Partner - Specialist

Hi,

Use this:

=Div (sum(a), (sum(b) - sum(c)))

manideep78
Partner - Specialist
Partner - Specialist

LET vDiff= Sum(b)-Sum(c);

then do this,

sum(a)/$(vDiff)

hope it helps

Not applicable
Author

Thank you!

Not applicable
Author

Thank you! It works

er_mohit
Master II
Master II

hi

your expression is absolutely write i don't know why it didn't give you correct answer..

sum(a)/(Sum(b)-Sum(c))

see the attached file