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

Exlude row with null values

Hi, please see the picture below.  How do I exclude the rows in the table where both the "First Circulator" AND "Primary Surgeon" columns are BOTH null?  Please help! thank you!

 

drohm002_0-1623690172342.png

 

1 Reply
sasikanth
Master
Master

HI, 

Try below calculated dim

 

if(Not isnull(First Circulator) OR not isnull(Primary Surgeon),1,null())

check the option "Suppress when value is Null" and hide this column from presentation tab.