topic Re: Expression Sum with a sum variable in QlikView

Expression Sum with a sum variable

Mon, 27 Jan 2014 09:25:08 GMT

I’m having problems with the below expression.

I have not made any selections in dimension other what is in this expression.

=sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>}$(vCO_POSIBLE_TURNOVER))

The varible “vCO_POSIBLE_TURNOVER” is

(sum($(vCO_NET_AMOUNT_EUR))+(sum($(vCOINVO_NET_AMOUNT_EUR))))

And this variable works outside this expression.

Thanks in advance.

Re: Expression Sum with a sum variable

alexandros17 — Mon, 27 Jan 2014 09:37:45 GMT

in your expresion instead of writeing

$(vCO_POSIBLE_TURNOVER))

write:

$(=$(vCO_POSIBLE_TURNOVER)) )

Re: Expression Sum with a sum variable

Mon, 27 Jan 2014 09:39:16 GMT

Michale,

Sum of sum will not work.

Modify your valriable so that it becomes A+B and not sum(A)+sum(B)

Fabrice

Re: Expression Sum with a sum variable

jonathandienst — Mon, 27 Jan 2014 10:05:45 GMT

You cannot nest SUMs directly; use aggr() if necessary - something like this:

sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} Aggr($(vCO_POSIBLE_TURNOVER), ChartDim1, ChartDim2, ...))

(where ChartDim1, ChartDim2 is a comma separated list of dimensions in your chart or table.

HTH

Jonathan

Re: Expression Sum with a sum variable

Mon, 27 Jan 2014 13:04:18 GMT

I thank you all for your help…… I have tried them but they did not succeeded, so I will keep on trying new ways to get this solved.

Michael

Re: Expression Sum with a sum variable

Mon, 27 Jan 2014 13:50:17 GMT

Hi Michael, Please use set Analysis also in the the variable :

LET vCO_POSIBLE_TURNOVER =

(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCO_NET_AMOUNT_EUR))+(sum({$<Calendar_YearAndMonth={'201401','201402','201403','201404'}>} $(vCOINVO_NET_AMOUNT_EUR))))

Re: Expression Sum with a sum variable

Mon, 27 Jan 2014 14:08:10 GMT

Thank you dathu.... this one worked 🙂