Variable calcuations not working online

Thu, 29 Jul 2010 17:31:05 GMT

I'm using variables to enable me to reuse complex calculations that include set analysis throughout a document. Everything works fine on the desktop application however when view the document through the web the calculations return a value of zero in some cases.

Here is an example of the variables and the equation behind it.

Equation returning zero result on web but not on desktop application: $(vPYGrossValueShipLocal)

Variable definition:

if(
GetSelectedCount([Ship Year]) > 0,
if(GetSelectedCount([Order Price Year]) > 0,
sum({$<[Ship Year] = {$(=max([Ship Year]) - 1)}, [Order Price Year] = {$(=max([Order Price Year]) - 1)}>}
[Gross Value Shipped Local]),
sum({$<[Ship Year] = {$(=max([Ship Year]) - 1)}>}
[Gross Value Shipped Local])
),

if(GetSelectedCount([Order Price Year]) > 0,
sum({$<[Order Price Year] = {$(=max([Order Price Year]) - 1)}>}
[Gross Value Shipped Local])))

Thanks for any help

topic Variable calcuations not working online in QlikView

Variable calcuations not working online