Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys
How to suppress the expression when their values are 0 ??????
Hi,
Right click on object ==> Presentation tab ==> Select expression ==> Check on <Supress Zero-Value>
Hope this help.
Regards,
Sokkorn
how to do it in a bar chart ????
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
Thanks for the reply but i don't have any dimension in my bar chart ......only expressions .......
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
Hi Manish,
If you can share some screenshot or sample qvw then it would be possible to understand your problem more accurately.
Thanks,
Amey.
dimension-> supress null value
and in presentation supress zero values
and uncheck show all value
hope this helps
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()).
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?