Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
garethct
Contributor

Suppress Null

Hi all,

I'm wondering if someone could help me.

As you can see on the below image I have created a table, I would like it to show just accounts that are 'flagged' however it is showing all accounts and putting a dash in the expression for those that aren't 'flagged'.

How do I hide these null values?

Capture.PNG

10 Replies
ecolomer
Honored Contributor II

Re: Suppress Null

Sorry because my QV is in spanish.

You can select option for non show null valuesin label presentation

p33.png

Partner
Partner

Re: Suppress Null

Hi,

For a Straight Table:
Chart Properties --> Dimensions tab--> Used Dimensions (on the right)..
select the field for which you do not want null values and tick "Suppress when Value is null" (see attachment)
For a Table box see ecolomerreply

qlikviewnovice
Valued Contributor II

Re: Suppress Null

Hi,

Properties->Presentation tab->Mark Omit Rows Where field is NULL.

sasiparupudi1
Honored Contributor III

Re: Suppress Null

please attach your application with sample data

MVP
MVP

Re: Suppress Null

I assume that the column Top Branch is an expression. For null/0 lines to be suppressed, every expression on the line must return a null or zero. So modify the Top Branch expression to something like:

     If(len(Column(2)) > 0, ...expression for top branch...)

This will return null if [Non Allocated] (Column 2) is null.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Arjunarao
Honored Contributor II

Re: Suppress Null

Hi use this in script. Hope this will help you.

If(len([Non Allocation]) > 0,[Non Allocation])

garethct
Contributor

Re: Suppress Null

Thanks everyone but none of the suggestions have worked.

I don't want to show the rows that do not have a 'flagged' in the non allocated column.

Any other suggestions? It seems like such an easy thing to do but I can't figure it out.

Thanks

MVP
MVP

Re: Suppress Null

Is Open Date an expression? If yes:

     =If(len(Column(3)) > 0, ...expression for open date...)

     =If(len(Column(3)) > 0, ...expression for top branch...)


Make sure that the column number is the correct expression number for the column titled [Non Alloc...], and the suppress null values is checked on the Properties | Presentation page.


If all the expressions return numeric 0 or null, the line will be suppressed. If the line is still showing check which expression is returning something other than 0 or blank.Blank strings will be displayed as they are not null.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Arjunarao
Honored Contributor II

Re: Suppress Null

Hi Gareth,

Can you attach the sample data? It would be easier to provide the solution. Thanks.