topic Re: Suppressing the Expression when their values are 0 in QlikView

Suppressing the Expression when their values are 0

Tue, 31 Jul 2012 03:05:50 GMT

hi guys

How to suppress the expression when their values are 0 ??????

Re: Suppressing the Expression when their values are 0

Sokkorn — Tue, 31 Jul 2012 03:15:13 GMT

Hi,

Right click on object ==> Presentation tab ==> Select expression ==> Check on <Supress Zero-Value>

Hope this help.

Regards,

Sokkorn

Re: Suppressing the Expression when their values are 0

Tue, 31 Jul 2012 03:33:47 GMT

how to do it in a bar chart ????

Re: Suppressing the Expression when their values are 0

Tue, 31 Jul 2012 03:44:37 GMT

Hi Manish,

In a bar chart, if the value of expression is zero then you dont get corresponding bars in the chart by default. However sometimes it is possible that dimension might show null value against a bar chart, in that case you need to check the option supress when value is null in Properties>>Dimension Tab.

Hope this will help.

Thanks,

Amey

Re: Suppressing the Expression when their values are 0

Tue, 31 Jul 2012 03:46:56 GMT

Thanks for the reply but i don't have any dimension in my bar chart ......only expressions .......

Re: Suppressing the Expression when their values are 0

Sokkorn — Tue, 31 Jul 2012 04:00:15 GMT

Hi,

Not sure this one can help you or not

Is is posible that you can share sreenshot and draw what you looking for?

Regards,

Sokkorn

Re: Suppressing the Expression when their values are 0

Tue, 31 Jul 2012 06:37:07 GMT

Hi Manish,

If you can share some screenshot or sample qvw then it would be possible to understand your problem more accurately.

Thanks,

Amey.

Re: Suppressing the Expression when their values are 0

SunilChauhan — Tue, 31 Jul 2012 06:41:24 GMT

dimension-> supress null value

and in presentation supress zero values

and uncheck show all value

hope this helps

Re: Suppressing the Expression when their values are 0

Anonymous — Thu, 01 May 2014 13:17:12 GMT

I have that problem too. For dimension, we have the option to suppress Zero values, but in QV 11.2 for expressions, i don't see an option to suppress the 0 values.

I need to know a way other than if(expression <> 0, expression, Null()).

Re: Suppressing the Expression when their values are 0

ThornOfCrowns — Thu, 01 May 2014 13:38:33 GMT

a) This thread is years old.

b) The question is Not Answered, so none of the replies are valid to your new question

c) What's wrong with using If(Expression<>0,Expresssion) that you need an alternative answer?

Re: Suppressing the Expression when their values are 0

Anonymous — Thu, 01 May 2014 14:29:34 GMT

Yes. I wonder if we have an alternative in the properties of the chart.

Re: Suppressing the Expression when their values are 0

Anonymous — Thu, 01 May 2014 15:45:32 GMT

In the expressions tab you can make each expression conditional so that it only shows if the expression<>0

If you have an expression Sum(Amount) then tick the conditional box and use Sum(Amount)<>0 as the condtion