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

[#2]

Hi,

That has loaded in without error,  however when I created a tablebox, and set one of the fields to ClosebyZero, is basically sets everything to NULL.

In my Opencall Table, I have about 4 items that the closedby value is set to NULL (meanning that the issue has not been closed by anyone).  All I want to do is create a Tablebox that will only report on those where the closedby is set to NULL.  Therefore my tablebox should only show 4 rows.

[jonathandienst · Accepted solution]

Hi

First off, you cannot use a Table Box to do what you require as the Table Box does not allow expressions. Use a straight table "chart" object:

     Dimension: cust_name (and any other dimension fields as required)

     Expression: If(Len(closedby) = 0, 1, 0)

In the chart properties, ensure "Suppress Zeroes" is checked. You can also hide the expression in chart properties | presentation - select the expression column, and click Hide Column.

Hope that helps

Jonathan

[muniyandi]

Hi,

Worte your sql:

select callref,priority,owner,cust_name,logdate,assigndate,closedby,closedate,probcode,fixcode,respondby,fixby,
withinresp,withinfix,completeby,compltdate,lastactdate,lastactby ,case when trim(closedby) is null  then 'yes' else 'no' END AS clflag

from opencall

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

order by callref desc

Next : your qlikview expression are if(clflag='yes',1,0)

[#5]

Thanks Jonathan, it is working as I want it to.

Also thanks for your help to Muni.