Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
arielg
Contributor
Contributor

How to hide measure if its a null or 0 value in a chart?

Hi! I am trying to create filtered views in a table, but can't figure out how to hide rows with measure having 0 or null value. I've tried disabling "Include 0 values" from data handling, and setting the output of this expression to display NUM values, but still not working. Expression below is calculating if date in Log for a record is within last day days. 

=IF((today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp)))<90,NUM(today(2)-daystart(max({<[Session Count] = {1}>} LogTimeStamp))),NUM(0))

 

Labels (1)
2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi, how about changing NUM(0) to NULL() for the else parameter?

luciancotea
Specialist
Specialist

If the row doesn't hide, it means that you have another measure with a non-zero value on that row.