
Re: Division Calculation in expression
Anil Samineni May 13, 2017 12:26 AM (in response to Vikas Nandanwar)You said P1, P2, P3 ... Pn. But all are string or numbers

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 12:29 AM (in response to Anil Samineni )@Anil,
Its a table where P1, P2 P3 are Profit numbers for Item1, Item2, Item3... Itemn corresponding to Final Value of V1, V2 V3

Re: Division Calculation in expression
Anil Samineni May 13, 2017 12:34 AM (in response to Vikas Nandanwar)Can you show data please how profit and and value looks?

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 12:37 AM (in response to Anil Samineni )Item Type value Profit Low Makeable C 1,302.40 78.10 Cubes M 1,178.10 94.20 Cubes M 2,077.50 145.40 Cubes M 3,945.92 315.70 Cubes M 1,952.50 156.20 High Makeable M 509.86 56.10 High Makeable M 3,063.95 76.60 High Makeable M 1,105.56 71.90 Blacks M 1,385.00 13.90 Blacks M 2,552.00 25.50 Blacks M 1,488.36 14.90

Re: Division Calculation in expression
Anil Samineni May 13, 2017 1:27 AM (in response to Vikas Nandanwar)
Vikas Nandanwar.qvw 156.2 K

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 1:50 AM (in response to Anil Samineni )Yes I am expecting this calculation
But when i put the below expression in Qlik sense,
Div(Sum(Profit),Sum(value))
the calculated field shows "0"

Re: Division Calculation in expression
Anil Samineni May 13, 2017 1:56 AM (in response to Vikas Nandanwar)
Sample Div.qvf 176.0 K




Re: Division Calculation in expression
mahesh kumar May 13, 2017 1:40 AM (in response to Vikas Nandanwar)
Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 1:50 AM (in response to mahesh kumar)NO

Re: Division Calculation in expression
mahesh kumar May 13, 2017 1:58 AM (in response to Vikas Nandanwar)as Per your expression Guage chart is showing result
is 4 is it correct?

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 1:59 AM (in response to mahesh kumar)Data I have provided should give me 5.1 as result in guage

Re: Division Calculation in expression
mahesh kumar May 13, 2017 2:05 AM (in response to Vikas Nandanwar)Hi
as per data it was showing result is 5

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 2:07 AM (in response to mahesh kumar)yes answer is 5

Re: Division Calculation in expression
mahesh kumar May 13, 2017 2:12 AM (in response to Vikas Nandanwar) 
Re: Division Calculation in expression
mahesh kumar May 13, 2017 2:19 AM (in response to Vikas Nandanwar)Hi please find the attached file

check.qvw 155.2 K

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 2:24 AM (in response to mahesh kumar)Ceil do not give me perfect value
I want
Profitability to be calculated as
(Sum of total profit) / (Sum of total Value)

Re: Division Calculation in expression
mahesh kumar May 13, 2017 2:50 AM (in response to Vikas Nandanwar)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)

Re: Division Calculation in expression
Vikas Nandanwar May 13, 2017 3:12 AM (in response to mahesh kumar)I got it
Sum(Profit)/Sum(Value) gave me the desired answer.
Thanks for the help.

Re: Division Calculation in expression
Ruben Marin May 13, 2017 4:02 AM (in response to Vikas Nandanwar)Hi Vikas, if your answer is solved please mark correct/helpful answers to close the thread.













