topic Buttot which seems rows when field value is null....??? in QlikView

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

Mon, 04 Jul 2011 07:14:36 GMT

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

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

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 08:28:07 GMT

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

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

Mon, 04 Jul 2011 08:36:53 GMT

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

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

Miguel_Angel_Baeyens — Mon, 04 Jul 2011 08:57:02 GMT

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

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

prieper — Mon, 04 Jul 2011 08:58:27 GMT

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

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

Mon, 04 Jul 2011 09:58:32 GMT

Thank you Miquel and Peter!

It helps:)))