how to remove blank cells from a column from qvd using qlik sense.

[neon]

how to remove blank cells from a column using qlik sense in a table.

[Thiago_Justen_ · Accepted solution]

Hi there,

I'll suggest you some tries based on my previous experiences.

In Load script you could try:

DataTable:

Load

YourFields

From YourQVD Where Len(Trim(BlankField))>0;

Or

DataTable:

Load

YourFields

From YourQVD Where Not IsNull(BlankField);

Then you can save a new qvd without those blank cells.

Hope it helps you.