Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

selvapraveen
New Contributor II

Removing a blank entries in a table used in charts

Hi ,

Is there a way to remove a blank entries in a table while creating a chart.

I have a table which i use to create a chart.as  below

order number     status      errorcode     time

1234                  new                         13-JUL-2013

2313                    rec             2          13-JUL-2013

2122                  red                             13-JUL-2013      

I need to create a chart showing only the orders in the error , the problem is that am not able ot filter out the rows that is blank.  I get a bar for the blank entry in the table.

1 Solution

Accepted Solutions
jpapador
Valued Contributor

Re: Removing a blank entries in a table used in charts

Try

If(Len(Trim(Error)) > 0, Count(Order_Num)

8 Replies
MVP
MVP

Re: Removing a blank entries in a table used in charts

I am not really sure what your chart needs to show, but you can probably make it work using a set expression like

=count({<errorcode = {">0"}>} time)

stevelord
Valued Contributor

Re: Removing a blank entries in a table used in charts

=if(errorcode, sum(whatever))

putting your expression inside the if(errorcode, ) part should tell it to give an answer only if there's a value in the errorcode field/column.

Other option is to suppress nulls somewhere in there, but I like the if statement because it keeps it clear what you are doing all in one place.

Update: try removing the time dimension and using the expression: if(errorcode, time) instead.  If it's a bar chart or pie chart, using errorcode as the dimension and if(errorcode, count(something)) as the expression should get you counts of somethings broken out by errorcode #.

selvapraveen
New Contributor II

Re: Removing a blank entries in a table used in charts

thanks Steve ,

the if condition works , if the error is a number, we have the error as alpha numberic it can be us C1 , C2 , H1 and so...

my table actually look link the bleow

order_numjStatusErrorTime
1234New212-Jul-13
1123RecA112-Jul-13
1232SND12-Jul-13
1234RECC212-Jul-13

When i use the if condition as if (error , count(order_num )) my bar char returns the vales only for the numbers and does not display all the alpha numeric code .

jpapador
Valued Contributor

Re: Removing a blank entries in a table used in charts

Are you trying to hide rows that don't have a value in the error field.  If so on the dimensions tab highlight the error dimension and check the box "Suppress when Value is null".  If you are using a table box this option is on the presentation tab.  Highlight the error field and check the "Omit Values where field is null" box.

What kind of object is it?  A table box or a chart.  If it's a chart what are your dimensions and expressions?

selvapraveen
New Contributor II

Re: Removing a blank entries in a table used in charts

the table is not having a null value, it has blanks. need to display the count of the orders with particular error code in the bar chart.

I dont need the count of orders with the blanks but with the below expression am gettting a bar for the count of balnks in the chart.

Am using a chart object and using a bar chart.

my exression is count(order_num)

dimensions is error

jpapador
Valued Contributor

Re: Removing a blank entries in a table used in charts

Try

If(Len(Trim(Error)) > 0, Count(Order_Num)

selvapraveen
New Contributor II

Re: Removing a blank entries in a table used in charts

yahooooo... that works thanks

stevelord
Valued Contributor

Re: Removing a blank entries in a table used in charts

Dang, and I’m so close to 1000 points!

Community Browser