topic Re: suppress the null values in table box in QlikView

suppress the null values in table box

Tue, 22 Apr 2014 10:03:51 GMT

want to suppress the null in my object by using edit script

pfa

Re: suppress the null values in table box

Gysbert_Wassenaar — Tue, 22 Apr 2014 10:07:41 GMT

Perhaps your data model isn't optimal. It's impossible to tell from the screenshot you attached.

Perhaps you should use a straight table object instead of a table box object with expressions for the last four columns like max(CAS_Updated_Date1) and maxstring(CAS_Value_Type1).

Re: suppress the null values in table box

alexandros17 — Tue, 22 Apr 2014 10:07:47 GMT

You cannot because the problem is related to data no to its visualization, you have 2 records each one with a value on a column only, you must normalize this situation.

Hope it helps

Re: suppress the null values in table box

Roop — Tue, 22 Apr 2014 10:10:38 GMT

I would always tend to use a Chart with the expressions defined as those columns that I wished to use as a suppression mechanism - This means it can work according to how you want.

Re: suppress the null values in table box

Tue, 22 Apr 2014 13:10:34 GMT

Suneel,

may be It's not Null Value Issue It's Data Model Issue,Please Upload the Data i can give u proper solutions either using left join concept.

Re: suppress the null values in table box

Tue, 22 Apr 2014 13:16:06 GMT

Am using below but i din,t get could u please me as early as possible

Calender:

LOAD CAD_Activity_ID,

CAS_Date_Value,

CAM_ID,

CAS_Remarks,

CAS_Status,

CAS_Updated_By,

if (CAS_Value_Type='A', CAS_Updated_Date)as CAS_Updated_Date1,

if (CAS_Value_Type='T', CAS_Updated_Date)as CAS_Updated_Date2,

// if (CAS_Updated_Date = (CAS_Value_Type='A'), 'CAS_Updated_Date')as Date1,

//if (CAS_Updated_Date = (CAS_Value_Type='T'), 'CAS_Updated_Date')as Date2,

if (CAS_Value_Type='A', 'A')as CAS_Value_Type1,

if (CAS_Value_Type='T', 'T')as CAS_Value_Type2 ,

CAS_Version

FROM

(qvd);

Right join

cal:

LOAD CAD_Activity_ID,

CAS_Date_Value,

CAM_ID,

CAS_Remarks,

if(IsNull( CAS_Updated_Date1) ,0,CAS_Updated_Date1)as CAS_Updated_Date1 ,

if(IsNull( CAS_Updated_Date2) ,0,CAS_Updated_Date2)as CAS_Updated_Date2,

CAS_Value_Type1,

CAS_Value_Type2

resident Calender

Re: Re: suppress the null values in table box

bertdijks — Tue, 22 Apr 2014 13:27:47 GMT

You can create a new table and select the max values, finnaly don't forget to drop the Original table!

Load Activity_ID,
     CAS_Date_Value,
     CAM_ID,
     CAS_Remarks,
     CAS_Status,
     CAS_Updated_By,
     max(CAS_Updated_Date1) as CAS_Updated_Date1,
max(CAS_Updated_Date2) as CAS_Updated_Date2,
     max(CAS_Value_Type1) as CAS_Value_Type1,
max(CAS_Value_Type2) as CAS_Value_Type2 ,
    CAS_Version
     resident Calender
     Group by Activity_ID,
     CAS_Date_Value,
     CAM_ID,
     CAS_Remarks,
     CAS_Status,
     CAS_Updated_By,
     CAS_Version;

     Drop table Calendar;