Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikview979
Valued Contributor

Re: Division Calculation in expression

as Per your expression  Guage chart is showing result

is 4 is it correct?

vikas_nandanwar
Contributor II

Re: Division Calculation in expression

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

qlikview979
Valued Contributor

Re: Division Calculation in expression

Hi

as per data it was showing  result is 5

vikas_nandanwar
Contributor II

Re: Division Calculation in expression

yes answer is 5

qlikview979
Valued Contributor

Re: Division Calculation in expression

is it ok

Untitled.png

qlikview979
Valued Contributor

Re: Division Calculation in expression

Hi please find the attached file

vikas_nandanwar
Contributor II

Re: Division Calculation in expression

Ceil do not give me perfect value

I want

Profitability to be calculated as

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

Highlighted
qlikview979
Valued Contributor

Re: Division Calculation in expression

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
Contributor II

Re: Division Calculation in expression

I got it

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

Thanks for the help.

Re: Division Calculation in expression

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

Community Browser