Solved: Hide rows that are null - Qlik Community

Report Inappropriate Content · ‎2014-12-22

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 · ‎2014-12-22

To me those look like fields that are blank (just spaces in them) not technically null which would be displayed as '-" instead of just a blank box. In the script use the trim command on shop talk:

Trim([Shop Talk]) as [Shop Talk]

That should solve your issue as long as the checkbox is checked to omit null rows.

View solution in original post

jpapador · ‎2014-12-22

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 · ‎2014-12-22

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

Report Inappropriate Content · ‎2014-12-22

I checked that box but it still doesnt hide the rows

saurabh5 · ‎2014-12-22

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

Report Inappropriate Content · ‎2014-12-22

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

Report Inappropriate Content · ‎2014-12-22

I check the box and nothing happens.

jpapador · ‎2014-12-22

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

Report Inappropriate Content · ‎2014-12-22

correct

jpapador · ‎2014-12-22

Do you have a screenshot of this?