Bug in Distribution Service?

Mon, 26 Jan 2026 18:19:17 GMT

I have a very simple document that works fine in qlikview desktop. It refreshes in 2 seconds but when refreshed in distribution service it never ends keeping the qvb.exe process at 100% cpu until ended by hand.

I found the problem to be the use of a variable in the formula of other variable. The exact code that hangs is:

set yr_amnt = if (year(SAL_DATE) = year($1) AND BEFORE_AFTER = 0, SAL_AMOUNT);

set mo_amnt = if (month(SAL_DATE) = month($1) and day(SAL_DATE) <= day($1), $(yr_amnt($1)));

Note that mo_amnt uses yr_amnt in the formula.

Then I changed the second variable to this:

set mo_amnt = if (month(SAL_DATE) = month($1) and

day(SAL_DATE) <= day($1) and

year(SAL_DATE) = year($1) and

BEFORE_AFTER = 0, SAL_AMOUNT);

Functionally equivalent, but is not using the first variable. This time the job finished in 2 seconds.

It looks like qlikview districution service runs in a infinite loop when evaluating variables inside other variables.....

Have anyone else experienced the same?

topic Bug in Distribution Service? in QlikView

Bug in Distribution Service?