Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table Box - Remove Certain Data

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

13 Replies
Not applicable
Author

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
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
muniyandi
Creator III
Creator III

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)

Not applicable
Author

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

Also thanks for your help to Muni.