Table Box - Remove Certain Data

[#1]

Hi,

I am New to Qlikview and I have ran a SQL command to bring all data from a specific table using an ODBC Connection. 

I used a Table Box to show all my data, however in the Table Box, I only want to show data that has field name closedby with NULL Values.

Therefore I do not want the data to show if the file name closedby hs any data in it.

Regards,

Jon Ditchfield

[sivarajs]

use isnull(closedby,0) while loading into qlikview

[#3]

Thanks for the reply Sivaraj,

I need all the data loading into Qlikview as I will be using the data elsewhere.  I just need for this table box to show only NULL values for the filed closedby. 

[sivarajs]

am not sure that we can calculate expression in table box

use if(isnull(closedby),closedby) as newfield in script and keep closedby as it is

Use newfield in tablebox to show null values

[senpradip007]

Hi Jon,

you can use Where Len(LTrim(RTrim(closedby)))=0 at the time of loading.

[#6]

Where abouts would I put this in, because if I enter this in my where statement of my SQL code, I get a message back saying it is incorrect syntax.

[#7]

Hi,

Where would I put this in, because If I enter it in my SQL Query on the Script page, I get a Syntax error.  The code I have got currently is:

select

callref,

priority,

owner,

cust_name,

logdate,
assigndate,
closedby,
closedate,
probcode,
fixcode,
respondby,
fixby,
withinresp,
withinfix,
completeby,
compltdate,
lastactdate,
lastactby

from opencall

where suppgroup IN ('FINANCIAL SYSTEMS','BUSINESS DEVELOPER')

order by callref desc

[MayilVahanan]

Hi

     Try like this,

     Load *,if(Len(Trim(Closedby)) = 0, Closedby) as ClosedbyZero;

select

callref,

priority,

owner,

cust_name,

logdate,
assigndate,
closedby,
closedate,
probcode,
fixcode,
respondby,
fixby,
withinresp,
withinfix,
completeby,
compltdate,
lastactdate,
lastactby

from opencall

where suppgroup IN ('FINANCIAL SYSTEMS','BUSINESS DEVELOPER')

order by callref desc

Hope it helps..

[#9]

Hi Mayil,

Unfortunately this didnt work, a message occurs when reloading my data saying:

Field not found - <closedby>

[MayilVahanan]

Hi

     Can you able to paste your script, which you used ?

     Load *, if(Len(Trim(closedby)) = 0, closedby) as ClosedbyZero;

     Select *  from tablename;

     Give error?