topic Re: Suppress Null in QlikView

Suppress Null

Anonymous — Tue, 18 Aug 2015 15:13:08 GMT

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?

Re: Suppress Null

ecolomer — Tue, 18 Aug 2015 15:21:07 GMT

Sorry because my QV is in spanish.

You can select option for non show null valuesin label presentation

Re: Suppress Null

vcanale — Tue, 18 Aug 2015 15:24:21 GMT

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 ecolomer‌reply

Re: Suppress Null

Anonymous — Tue, 18 Aug 2015 15:28:26 GMT

Hi,

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

Re: Suppress Null

sasiparupudi1 — Wed, 19 Aug 2015 06:00:50 GMT

please attach your application with sample data

Re: Suppress Null

jonathandienst — Wed, 19 Aug 2015 06:20:51 GMT

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.

Re: Suppress Null

qlikviewwizard — Wed, 19 Aug 2015 06:46:33 GMT

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

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

Re: Suppress Null

Anonymous — Thu, 20 Aug 2015 14:19:22 GMT

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

Re: Suppress Null

jonathandienst — Thu, 20 Aug 2015 14:25:52 GMT

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.

Re: Suppress Null

qlikviewwizard — Thu, 20 Aug 2015 14:28:44 GMT

Hi Gareth,

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

Re: Suppress Null

Peter_Cammaert — Thu, 20 Aug 2015 14:40:29 GMT

It really is an easy thing to do, but the fact that we don't know anything about the logic and expressions behind your chart forces us to keep guessing randomly as to what could work eventually.

The more details you provide, the faster you'll have a working solution.