topic Table columns totals dissapear in Server View (fine in Developer view) in QlikView

Table columns totals dissapear in Server View (fine in Developer view)

Wed, 23 Mar 2011 15:25:09 GMT

Hi, im having a problem with column figures appearing correctly in developer view but NOT in server view.

The problem only affects 2 columns Monthly Budget + Monthly Actual (see developer & server screenshots below).

DEVELOPER VIEW (CORRECT)

SERVER VIEW (INCORRECT - MISSING TOTALS)

The afected column expressions are below:

--------------------

Monthly Budget expression

Sum({< Period={$(=max(Period))},Type={'GBP'},[Subj 12.10A]={'I&E'}>} [Budget])

Monthly Actual expression

Sum({< Period = {$(=max(Period))},Type={'GBP'},[Subj 12.10A]={'I&E'}>} [Actual])

------------------------

Basically i want the expression to always pick the max period of the selection. e.g. if periods 1-9 are selected then it will only take period 9.

Please help????

Table columns totals dissapear in Server View (fine in Developer view)

Thu, 24 Mar 2011 16:00:28 GMT

ANYONE?

Table columns totals dissapear in Server View (fine in Developer view)

rwunderlich — Thu, 24 Mar 2011 16:58:31 GMT

Are your Developer and Server the same version? If not, what version is the server?

Table columns totals dissapear in Server View (fine in Developer view)

Fri, 25 Mar 2011 10:53:05 GMT

Hi Rob, I believe server and developer are the same. My developer version is 9.00.7502.8 SR5

See details taken from console management.

Server System Info - product vers = 9.00.7440.8

Does this shed any light on the problem?

Table columns totals dissapear in Server View (fine in Developer view)

Fri, 25 Mar 2011 11:13:30 GMT

Looks like your server is running a different SR of v9 to developer and thats probably causing the issue. Not sure what SR it is but SR4 is 9.0.7469.8 so its lower than that....

Gordon

Table columns totals dissapear in Server View (fine in Developer view)

suniljain — Fri, 25 Mar 2011 11:24:17 GMT

QV Server and Developer should have same version otherwise normally you will get this types of error.

Table columns totals dissapear in Server View (fine in Developer view)

rwunderlich — Sun, 27 Mar 2011 03:33:04 GMT

7440 is SR3 which is almost a year old. As a first step, you may want to upgrade the server to see if that fixes the problem.

Table columns totals dissapear in Server View (fine in Developer view)

suniljain — Mon, 28 Mar 2011 06:04:07 GMT

Pls updrade to QV9 SR7 .

Table columns totals dissapear in Server View (fine in Developer view)

Mon, 28 Mar 2011 09:09:01 GMT

Dear all, thanks for your input. I will certainly look at the server / developer compatibility issue.

In your experience can we be certain that this isnt a problem with the formulas?

--------------------------------

Monthly Budget expression

Sum({< Period={$(=max(Period))},Type={'GBP'},[Subj 12.10A]={'I&E'}>} [Budget])

Monthly Actual expression

Sum({< Period = {$(=max(Period))},Type={'GBP'},[Subj 12.10A]={'I&E'}>} [Actual])

-------------------------------

As when i remove the '< Period={$(=max(Period)' part of the formulas the columns appear correctly.

Thanks