Variable not summing as anticipated

NickBentley — Fri, 23 Apr 2021 06:28:43 GMT

I am using the following expression to sum the the sales for the next four weeks from last year.

=Sum({<Chron_Week = {"$(dMaxChronWeek-52)"},Fy_Wk=,FY_Year=>}Units_Sold)+ Sum({<Chron_Week = {"$(dMaxChronWeek-51)"},Fy_Wk=,FY_Year=>}Units_Sold)+ Sum({<Chron_Week = {"$(dMaxChronWeek-50)"},Fy_Wk=,FY_Year=>}Units_Sold)+ Sum({<Chron_Week = {"$(dMaxChronWeek-49)"},Fy_Wk=,FY_Year=>}Units_Sold)

The expression is working fine and giving the expected result.

Because I am going to be using the same expression in multiple tables, I have converted it to a variable:

dUnitsLY+4weeks

However, when I write this variable in the expression as $(dUnitsLY+4weeks), I get the overall number(914) listed for every customer and not the customer's individual sales for that period. When I use the extended expression (as above) it does results for individual customers.

Can some please explain why the expression is giving a different result when wrapped in the variable?

Thanks in advance!

Cheers,

Nick

Re: Variable not summing as anticipated

tresB — Fri, 23 Apr 2021 06:32:32 GMT

While defining the variable, remove the preceding '=' and try.

Re: Variable not summing as anticipated

NickBentley — Fri, 23 Apr 2021 06:48:53 GMT

Works a treat.

Thanks tresesco

topic Re: Variable not summing as anticipated in QlikView

Variable not summing as anticipated

Re: Variable not summing as anticipated

Re: Variable not summing as anticipated