nulls in calculated dimension

Mon, 18 Feb 2013 17:02:58 GMT

Been stuck on this issue for some time now. Trying to use the following calculated dimension and getting different results in development vs. web-based access. Need to place folks into various buckets based on blood pressure tests:

In the development environment, I am getting the people who should be in the no results bucket forced into a column with a null heading. On the web-based side, all of these people are correctly placed, with no one showing up as null in the calculated dimension. They both use the same data, dimensions, and expressions in the object. Any thoughts as to why this might be happening?

=if(isnull(Diastolic) or isnull(Systolic),dual('No Results',4),

if(Diastolic<80 and Systolic<120,Dual('Normal < 120/80',1),

if(Diastolic>89 or Systolic>139,Dual('Hypertension >=140/90',3),Dual('Prehypertension 120/80 - 139/89',2))))

Re: nulls in calculated dimension

danielrozental — Mon, 18 Feb 2013 17:46:22 GMT

You could probably just avoid using a calculated dimension.

Re: nulls in calculated dimension

Mon, 18 Feb 2013 17:56:53 GMT

as simple as that sounds, it worked. i still am confused as to why the results would be different in development vs. server.

topic nulls in calculated dimension in QlikView

nulls in calculated dimension

Re: nulls in calculated dimension

Re: nulls in calculated dimension