Remove empty rows in table

Kunkulis — Thu, 24 Jun 2021 08:54:16 GMT

Hello,

We have a dynamic straight table, meaning you have available check-boxes with column names, once selected they show up in the straight table using

=substringcount('|'&GetFieldSelections(DetailDim_, '|', 100)&'|','Column Name')

This works fine on its own, if I select one column, then we don't get any empty rows. Consider this example:

ID	Name	Viewer	Editor
Example1	Person1
Example1	Person2		Person2
Example1	Person3	Person3
Example1	Person4		Person4
Example1	Person5		Person5
Example1	Person6

Empty cells are created as '', they are not null

The above table is the data we use. If i just select "ID" I will see 1 row of "Example1", as it should, but once I add to selection "Viewer", the Straight Table will look like this:

ID	Viewer
Example1	Person3
Example1

I tried changing the data from '' to null, which kind of helped, with ID and Viewer selected I only get 1 row, but when I add Editor, I get 0 rows, but I would expect it to look like this:

ID	Viewer	Editor
Example1		Person2
Example1	Person3
Example1		Person4
Example1		Person5

Any ideas how this could be achieved?

topic Remove empty rows in table in QlikView

Remove empty rows in table