Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
drohm002
Creator II
Creator 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.