Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

galrion82
New Contributor III

How to hide rows with 0 in expression

Hello everyone,

I just started using Qlik Sense after working with Qlikview for over 7 years.

I was wondering if it's possible to only show lines that have a non-null value in expression for a table (Similar to Presentation - Suppress Zero Values in Qlikview).

Thanks in advance,

Alecs

3 Replies
Employee
Employee

Re: How to hide rows with 0 in expression

The setting is not there so it makes conditional null approach to filtering expressions  (IE:   IF( condition, value)   )  not permissible in exactly the same way.

I was able to replicate the effect using the condition on the dimension , because there is a 'show nulls' checkbox there. (see below)

Other ways to filter out NULLs in the expression like  set analysis will work too.

If there is a very specific technique or approach you are asking about...please post.

Untitled.png

Employee
Employee

Re: How to hide rows with 0 in expression

Did yoh get an answer to your question?

Not applicable

Re: How to hide rows with 0 in expression

Can use below expression instead?

IF (sum(SALES)=0,'',OrderID)

I try but not working..