topic Re: adding in an expression in QlikView

adding in an expression

rcorcoran — Wed, 11 Feb 2015 15:09:15 GMT

Hi I have the expression below basically I want the sum of CAMHS120=1,2 divided by the sum of (CAMHS120 =1,2 and CAMHS124=7,8,9)

The expression here doesn't work for me

num(Sum({$<[CAMHS120]={1,2},ReferredMM={1}>}ActualValue)/(Sum({$<[CAMHS120]={1,2},[CAMHS121]={7,8,9},ReferredMM={1}>}ActualValue)), '##0.0%'),

giakoum — Wed, 11 Feb 2015 15:26:38 GMT

looks correct. try putting single or double quotes on the values (i.e. [CAMHS120]={'1','2'}

Does any part of the expression work?

It would be great if you could post a sample app.

Anonymous — Wed, 11 Feb 2015 15:30:04 GMT

Hello,

Should work by all means.

Try to break down the problem.

- Get rid of num().

- Try only first expression.

- Try only second expression.

Maybe related to division by zero.

Serhan