Hide rows that are null

[#1]

Hello,

I have created a table in qlikview that has the collumns 'Day', 'Topic', and 'Shop Talk'.  I want to only display the rows where 'Shop Talk' has a value.  I've been using the following statement, but it is not working

if

(Len([Shop Talk]) > 0, Only(Day))

Where do i put this expression?  I'm not exactly sure where to put it.  I cant seem to get it to work.

[jpapador]

If you are using a table box, simply in the properties go to presentation tab.  Highlight the field you want and suppress values when field is null.

[Anonymous]

Try making your table a chart of type Straight Table.

• Set Dimension to 'Day' and 'Topic'
• Set the Expression to only([Shop Talk])
• On the Presentation tab tick Suppress Zero-Values and Suppress Missing

[#4]

I checked that box but it still doesnt hide the rows

[saurabh5]

hi Brandon,

if you have a straight table or a pivot table, then for the dimenssion 'Shop talk' just check mark 'Suppress when value is null' and it will get what you are aiming for, you dont need any expression for that i suppose.

Regards

Saurabh

[#6]

On the dimension tab of your table properties, select 'Suppress When Value Is Null'

[#7]

I check the box and nothing happens.

[jpapador]

So even with that box checked you are still seeing '-' (null values) in the shop talk column?

[#9]

correct

[jpapador]

Do you have a screenshot of this?