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: 
vikas_nandanwar
Creator II
Creator II

Division Calculation in expression

Hi All,

I want expression to be written in Guage for calculating Profitability with given parameters -

Where

Profit is - P1,P2,P3....Pn

Value is - V1,V2,V3....Vn

Guage should calculate - Profitability -

(P1+P2+P3+....+Pn) / (V1+V2+V3+...+Vn)


div(Sum(Profit),Sum(value)) is not working in expression


Please guide


Thanks,

Vikas

19 Replies
qlikview979
Specialist
Specialist

as Per your expression  Guage chart is showing result

is 4 is it correct?

vikas_nandanwar
Creator II
Creator II
Author

Data I have provided should give me 5.1 as result in guage

qlikview979
Specialist
Specialist

Hi

as per data it was showing  result is 5

vikas_nandanwar
Creator II
Creator II
Author

yes answer is 5

qlikview979
Specialist
Specialist

is it ok

Untitled.png

qlikview979
Specialist
Specialist

Hi please find the attached file

vikas_nandanwar
Creator II
Creator II
Author

Ceil do not give me perfect value

I want

Profitability to be calculated as

(Sum of total profit) / (Sum of total Value)

qlikview979
Specialist
Specialist

Hi

as per data its giving the result like

4.693917269

if u want check in text object like  :-    =sum(TOTAL  Profit)/sum( TOTAL value)

vikas_nandanwar
Creator II
Creator II
Author

I got it

Sum(Profit)/Sum(Value) gave me the desired answer.

Thanks for the help.

rubenmarin

Hi Vikas, if your answer is solved please mark correct/helpful answers to close the thread.