Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

nulls in calculated dimension

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))))

1 Solution

Accepted Solutions
Highlighted
danielrozental
Honored Contributor II

Re: nulls in calculated dimension

You could probably just avoid using a calculated dimension.

2 Replies
Highlighted
danielrozental
Honored Contributor II

Re: nulls in calculated dimension

You could probably just avoid using a calculated dimension.

Not applicable

Re: nulls in calculated dimension

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

Community Browser