topic Re: Supress zero value expressions in QlikView

Supress zero value expressions

Tue, 18 Mar 2014 08:43:08 GMT

I have a problem with presenting a clustered chart. I have several variables (expressions) (A, B, C, etc) that have values i.e. in 2012, some of these A, B and C have values in previous years. When no data is present in any of these previous years, the letter (A,B, C) is

stilldisplayed. How can I turn this off? A in 2012 is the same A as in 2011, 2010, etc. The same is applicable for B, C, etc.

Expression:

(sum(Variable1) + sum(Variable2))

sum([Variable3])

Re: Supress zero value expressions

MK_QSL — Tue, 18 Mar 2014 09:16:59 GMT

Can you post your sample data?

Re: Supress zero value expressions

senpradip007 — Tue, 18 Mar 2014 09:19:32 GMT

Hi Wilfred.

try this

if(

((sum(Variable1) + sum(Variable2))

sum([Variable3])) > 0,

(sum(Variable1) + sum(Variable2))

sum([Variable3])

)

Re: Supress zero value expressions

Fri, 11 Apr 2014 15:01:59 GMT

Unfortunately, this does not work.

Re: Supress zero value expressions

yduval75 — Fri, 11 Apr 2014 15:05:53 GMT

Suppress Zero Value in presentation tab ?

Re: Supress zero value expressions

Fri, 11 Apr 2014 15:20:26 GMT

I've already done that. For example, when an entity has certain data in 2012 (higher than 0), but not in 2011 (value is 0, not NULL/NA), this entity will be shown in 2011. QlikView seems prefer to show that this entity has no data in 2011. I do not need to see that, by showing an 'empty' bar.

Re: Supress zero value expressions

Fri, 18 Apr 2014 14:59:47 GMT

Does anyone have an idea?

Re: Supress zero value expressions

santharubban — Fri, 18 Apr 2014 18:01:59 GMT

did you try 'Supress when null value' in dimension

Re: Supress zero value expressions

Fri, 18 Apr 2014 18:20:32 GMT

Yes. The expression is a follows:

(sum(Variable1) + sum(Variable2))

sum([Variable3])

where both variable 1 and 2 and/or 3 variable may have a value of 0 in some years: in any case, the outcome is 0. Where the same dimension (A, B, C ,etc) can have a value in a certain year higher than 0.

When no data is present in any of these previous years, the letter (A,B, C) is still displayed.

Re: Supress zero value expressions

Mon, 28 Apr 2014 12:32:13 GMT

In the attached example it is working. Number 3 is not shown in the figure. Just how to translate this to my situation is not clear, i.e. with the use of the expression =if(isnull(Values)<>-1,cUSTOMERiD)

(sum(Variable1) + sum(Variable2))

sum([Variable3])

Is it because I'm not using a single dimension?

Re: Supress zero value expressions

lironbaram — Mon, 28 Apr 2014 12:58:32 GMT

the answer is yes

because you use more then one dimension

then you see all the values in each dimension that have at least one time where they have value that is bigger then 0

Re: Supress zero value expressions

Mon, 28 Apr 2014 13:21:54 GMT

Okay, but my data model looks like this (se screenshot; don't know how to upload a file). Where E, F, I and J do have data in 2012 for the three different variables, but for the same variables in 2011, no data is present at all. Yet these four IDs are shown in 2011. 'Supress when null value' isn't working.

Re: Supress zero value expressions

Sun, 18 May 2014 20:01:18 GMT

Liron Bra'am: if you see the example below. In some cases, each dimension has a value of zero. A solution is hopefully possible. I use data of many years, which can show thereby many gaps between the barcharts. For readability not desirable.