Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

divide by expression

Hello

I want to devide some values but i cant find the correct expression

i've a tabe witch som coloms with sum expressions and a total

sum (), sum () , sum () and sum ()+sum ()+sum()

now i want to make an other expression wich gives me the divide of , and

sum +sum +sum/3 does not give the correct answer ex a=5, b=4 and c=7 outcome shout be 16/3=5,3 but outco...

Avg (++) does not work either, outcome qlikview = 16

Avg (sum () + sum () + sum () gives error in expression

below a screenshot

http://img585.imageshack.us/img585/2238/qlikview.jpg

help me

grtz Ed

Tags (1)
1 Solution

Accepted Solutions

Re: divide by expression

HI

(sum (a)+sum (b)+sum(c))/3

Hope it helps

2 Replies

Re: divide by expression

HI

(sum (a)+sum (b)+sum(c))/3

Hope it helps

Not applicable

Re: divide by expression

yeh thanx was correct,

grtz Ed

Community Browser