Discussion Board for collaboration related to Creating Analytics for QlikView.
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
Go to Solution.
(sum (a)+sum (b)+sum(c))/3
Hope it helps
yeh thanx was correct,