Buttot which seems rows when field value is null....???

[#1]

How can I make the button, which seems me only those rows, where one of field value is null???

[Miguel_Angel_Baeyens]

Hello Aleksandra,

Can you please elaborate on your requirements? It's a button object what you are using? What filers or actions are you using in it?

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[#3]

I wish that button allows to see only those rows on the table, with missing "client name", where client name is null...

[Miguel_Angel_Baeyens]

Hi Aleksandra,

Those missing values are coming as null (or missing) from the database or are they results of the aggregation missing dimensions? In the first case, I'd suggest you to assign a value in the script so you can check for them later. In the second case, Nulls cannot be selected in QlikView, because they don't exist (it's not an empty value).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[prieper]

Think it makes more sense to have a "real" name in all your relevant datafields.

• In a flat table you may insert: IF(LEN(originalClientName) = 0, 'N/A', originalClientName) AS ClientName.
• If loading in a separate table script may look like:
  SET OTHERSYMBOL = +;
  Data: LOAD Client, ..... FROM ...;
  Clients: LEFT KEEP (Data) LOAD Client, ClientName FROM ...;
  MissingClients: LOAD * INLINE[Client, ClientName
  +, N/A];
• If intented to find some outliers you may create a straight-table with calculated dimension:
  IF(LEN(ClientName) = 0, Client)
  and exclude NULL-values

HTH
Peter

[#6]

Thank you Miquel and Peter!

It helps:)))