Division Calculation in expression

[vikas_nandanwar]

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

[Anil_Babu_Samineni]

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

[vikas_nandanwar]

@Anil,

Its a table where P1, P2 P3 are Profit numbers for Item1, Item2, Item3... Itemn corresponding to Final Value of V1, V2 V3

[Anil_Babu_Samineni]

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

[vikas_nandanwar]

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

[Anil_Babu_Samineni]

Seems working

Or

[qlikview979]

Hi are you expecting like this in Guage chart

[vikas_nandanwar]

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"

[vikas_nandanwar]

NO

[Anil_Babu_Samineni]

Seems, Qliksense also working