topic Re: Hide rows that are null in QlikView

Hide rows that are null

Fri, 20 Nov 2020 18:02:30 GMT

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

(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.

Re: Hide rows that are null

jpapador — Mon, 22 Dec 2014 18:43:19 GMT

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.

Re: Hide rows that are null

Anonymous — Mon, 22 Dec 2014 18:46:54 GMT

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

Re: Hide rows that are null

Mon, 22 Dec 2014 18:51:56 GMT

I checked that box but it still doesnt hide the rows

Re: Hide rows that are null

saurabh5 — Mon, 22 Dec 2014 18:56:25 GMT

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

Re: Hide rows that are null

Mon, 22 Dec 2014 18:58:02 GMT

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

Re: Hide rows that are null

Mon, 22 Dec 2014 19:20:44 GMT

I check the box and nothing happens.

Re: Hide rows that are null

jpapador — Mon, 22 Dec 2014 19:22:47 GMT

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

Re: Hide rows that are null

Mon, 22 Dec 2014 19:23:56 GMT

correct

Re: Hide rows that are null

jpapador — Mon, 22 Dec 2014 19:25:18 GMT

Do you have a screenshot of this?

Re: Hide rows that are null

Mon, 22 Dec 2014 19:27:51 GMT

Re: Hide rows that are null

jpapador — Mon, 22 Dec 2014 19:34:05 GMT

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.