# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Contributor 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

1 Solution

Accepted Solutions
Contributor II

## Re: Division Calculation in expression

I got it

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

Thanks for the help.

19 Replies
MVP

## Re: Division Calculation in expression

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

Life is so rich, and we need to respect to the life !!!
Contributor II

## Re: Division Calculation in expression

@Anil,

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

MVP

## Re: Division Calculation in expression

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

Life is so rich, and we need to respect to the life !!!
Highlighted
Contributor II

## Re: Division Calculation in expression

 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
MVP

## Re: Division Calculation in expression

Seems working

Or

Life is so rich, and we need to respect to the life !!!
Valued Contributor

## Re: Division Calculation in expression

Hi are you expecting like this in Guage chart

Contributor II

## Re: Division Calculation in expression

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"

Contributor II

NO

MVP

## Re: Division Calculation in expression

Seems, Qliksense also working

Life is so rich, and we need to respect to the life !!!
Community Browser