Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
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