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

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. 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

 

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