topic Re: Exlude row with null values in QlikView

Exlude row with null values

drohm002 — Mon, 14 Jun 2021 17:07:47 GMT

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!

Re: Exlude row with null values

sasikanth — Mon, 14 Jun 2021 17:44:23 GMT

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.