Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanand3535
Contributor

Remove blank values from database in qlik sense

I have a field called REASON_MISSED_INJURY_ID in my database.

It has around 51437 values including null or blank.

I want to remove all the null and blank values from the database.

So How can I do this?

4 Replies

Re: Remove blank values from database in qlik sense

While loading use something like below

LOAD F1, F2, F3 etc from tablename

where Not IsNull(REASON_MISSED_INJURY_ID) or Len(Trim(REASON_MISSED_INJURY_ID)) <> 0;


or

Select

F1, F2, F3

From YourDataBaseTable

Where Not  IsNull(REASON_MISSED_INJURY_ID);

vanand3535
Contributor

Re: Remove blank values from database in qlik sense

I tried two syntaxes:-

len(REASON_MISSED_INJURY_ID )>0


and


trim(len(REASON_MISSED_INJURY_ID ))>0


brunobertels
Valued Contributor

Re: Remove blank values from database in qlik sense

Hi

try this with a where clause

table:

LOAD

    a,

    b,

     c

FROM source

WHERE len(REASON_MISSED_INJURY_ID)>0;

sasiparupudi1
Honored Contributor III

Re: Remove blank values from database in qlik sense

Try

len(Trim(REASON_MISSED_INJURY_ID ))>0

Community Browser