Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Suppressing the Expression when their values are 0

hi guys

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

11 Replies
Sokkorn
Master
Master

Hi,

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

Untitled.png

Hope this help.

Regards,

Sokkorn

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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

Sokkorn
Master
Master

Hi,

Not sure this one can help you or not

Untitled.png

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

Regards,

Sokkorn

Not applicable
Author

Hi Manish,

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

Thanks,

Amey.

Sunil_Chauhan
Champion
Champion

dimension-> supress null value

and in presentation supress zero values

and uncheck show all value

hope this helps

vamshi_1957
Creator II
Creator II

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()).

ThornOfCrowns
Specialist II
Specialist II

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?