Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Blank or Missing Records in Calculated Dimension


I am having a problem with some report output.

I want all the results to be either 'Internal' or 'External'

There is a table SOLD_TO contating customer information including InternalExternal, and my calculated dimension in hte chart results in 3 different possibilites, Internal, External and '-'

When a customer does not exist in SOLD_TO I want them to fall under External.  The code below (I have tried both) works in each case on my desktop but when i put it on the Access Point, the missing customers do not fall under External, rather the show up in the '-' output.


=if(not IsNull([InternalExternal]),[InternalExternal],'External')

Is there some server setting that causes this???




1 Reply
Former Employee
Former Employee

Really need sample QVW file in this case to do testing and looking into things in order to determine where the issue may lie.  

It would appear to me that you have something going on with the Null values or something though, and that may be a setting in the QVS settings, but generally you control that in the Script Set statements, but you may want to check the QVS Settings.ini file to see if someone put in a related setting there that may be overriding things etc.  About the best I can offer with what you have provided.  One thing you may want to do is compare your Desktop Settings.ini to the QVS Settings.ini file to see what may be missing or set differently that way.  


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.