topic Re: Table Box/ Straight Table in QlikView

Table Box/ Straight Table

Thu, 16 Oct 2014 16:49:09 GMT

Hi All

I have a table box consisting of fields:

[NAME] [GUID] [USER_ID] [MODEL]

I only want the table to populate results if the "Model" field is not null based on the selection criteria.

How can I do this?

simondachstr — Thu, 16 Oct 2014 16:53:00 GMT

Think of maybe creating a straight table instead and suppressing nulls on the Model field

MK_QSL — Thu, 16 Oct 2014 16:54:48 GMT

Instead of MODEL use below

If(IsNull(MODEL) or LEN(TRIM(MODEL))=0,NULL(),1) as MODEL

Now create a table box and go to presentation tab...

SELECT MODEL and tick Omit Rows Where field is NULL

Thu, 16 Oct 2014 17:12:36 GMT

Hi Manish

I'm pulling the MODEL field from a SQL table so therefore I can't use the QV expresion.

Or should I first get it from SQL then write the expression to recreate the field?

Thu, 16 Oct 2014 18:02:17 GMT

Tabla:

SQL

SELECT *

FROM TABLE;

then in the resident load use the expression given by Manish.

LOAD

If(IsNull(MODEL) or LEN(TRIM(MODEL))=0,NULL(),1) as MODEL

RESIDENT Tabla;

Hope it helps!

Regards