Supress zero value expressions

[#1]

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])

[MK_QSL]

Can you post your sample data?

[senpradip007]

Hi Wilfred.

try this

if(

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

/

sum([Variable3])) > 0,

(sum(Variable1) + sum(Variable2))

/

sum([Variable3])

)

[#4]

Unfortunately, this does not work.

[yduval75]

Suppress Zero Value in presentation tab ?

[#6]

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.

[#7]

Does anyone have an idea?

[santharubban]

did you try 'Supress when null value' in dimension

[#9]

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.

[#10]

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?