Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do i allow null row in my table without the overflow (-)field?

I have a pivot table and have some null data tied to some fields i need to show the items data with the null. what do i do?

Note: I need the null but i dont need the overflow - field

6 Replies
petter
Partner - Champion III
Partner - Champion III

the dash ( - ) does not mean overflow. It is a way of showing null-values. But you can chose a different visual representation by overriding the dash - as that is the default.

On the Chart Properties and the Representation tab you will find Null Symbol furthest down to the left.

Not applicable
Author

This removed the Null rows completely. I need to remove only the overflow in my table. I need to still show the row but not the overflow -

petter
Partner - Champion III
Partner - Champion III

I don't understand what you mean with overflow... could you please explain?

Not applicable
Author

An extra empty field with null

petter
Partner - Champion III
Partner - Champion III

You mean an extra dimension value that is null?

petter
Partner - Champion III
Partner - Champion III

Could you provide us with a screenshot of both the Dimension tab, the Expression tab and the Presentation tab of the chart that you are having problems with?