topic Re: Division Calculation in expression in QlikView

Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 04:21:48 GMT

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

Re: Division Calculation in expression

Anil_Babu_Samineni — Sat, 13 May 2017 04:26:40 GMT

You said P1, P2, P3 ... Pn. But all are string or numbers

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 04:29:15 GMT

@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_Babu_Samineni — Sat, 13 May 2017 04:34:30 GMT

Can you show data please how profit and and value looks?

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 04:37:51 GMT

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_Babu_Samineni — Sat, 13 May 2017 05:27:30 GMT

Seems working

Re: Division Calculation in expression

qlikview979 — Sat, 13 May 2017 05:40:08 GMT

Hi are you expecting like this in Guage chart

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 05:50:17 GMT

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

vikas_nandanwar — Sat, 13 May 2017 05:50:27 GMT

Re: Division Calculation in expression

Anil_Babu_Samineni — Sat, 13 May 2017 05:56:18 GMT

Seems, Qliksense also working

Re: Division Calculation in expression

qlikview979 — Sat, 13 May 2017 05:58:24 GMT

as Per your expression Guage chart is showing result

is 4 is it correct?

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 05:59:40 GMT

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

Re: Division Calculation in expression

qlikview979 — Sat, 13 May 2017 06:05:49 GMT

as per data it was showing result is 5

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 06:07:03 GMT

yes answer is 5

Re: Division Calculation in expression

qlikview979 — Sat, 13 May 2017 06:12:57 GMT

is it ok

Re: Division Calculation in expression

qlikview979 — Sat, 13 May 2017 06:19:54 GMT

Hi please find the attached file

Re: Division Calculation in expression

vikas_nandanwar — Sat, 13 May 2017 06:24:13 GMT

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

qlikview979 — Sat, 13 May 2017 06:50:00 GMT

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 — Sat, 13 May 2017 07:12:09 GMT

I got it

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

Thanks for the help.

Re: Division Calculation in expression

rubenmarin — Sat, 13 May 2017 08:02:03 GMT

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