Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bi Query not displaying all data due to null entries

HI everyone.

This is my first time here so I hope my question is in the right place and my format is correct.

So I have a problem with Bi Query and its isnull and isnotnull qualifications. My query works with around 500 to 1000 rows of data at a time. The main problem is one of the columns has both numbers ranging from 0-100 and blank cells. When I include this column as a result I want displayed it cuts off about half the rows from the results due to the blank space.

So my first fix was to include the column as a query as well and have it set to AND(col10 isnull OR col10 isnotnull). The results are the same, The half with blank spaces missing.

Second fix was to try and just pull null results and that came up with: No data found.

Third attempt is the same as the second but instead of null I tried pulling white space using the bi query special char {' '}   Result: no data Found

Am I missing something key here about the use of isnull and isnotnull or is there an extra step after these ones which I have not stumbled upon?

All my work so far has been based on what little resources I can find online and the Bi Query inbuilt help.

Anything I can try and mess with or test would be greatly appreciated.

Thanks in Advance


Former Member
Not what you were looking for? View more on this topic or Ask a question