https://community.qlik.com/t5/App-Development/If-Isnull/m-p/1967865#M79781 <P>Hi all,&nbsp;</P> <P>I have a pivot table. With field 'Buisness' as a dimension. I then have date.month in column with values.&nbsp;</P> <P>I then have fields which contain reward payments. I have columns called LeadTimeReward and LeadTimeMissed.&nbsp;</P> <P>What I want to happen is for my table to show the LeadTimeReward as standard, then, if null, return LeadTimeMissed as value in Red Bold font. Can anyone please help?&nbsp;</P> <P>&nbsp;</P> <P>Thanks!</P> Thu, 11 Aug 2022 15:45:22 GMT Scott_Data 2022-08-11T15:45:22Z https://community.qlik.com/t5/App-Development/If-Isnull/m-p/1967865#M79781 <P>Hi all,&nbsp;</P> <P>I have a pivot table. With field 'Buisness' as a dimension. I then have date.month in column with values.&nbsp;</P> <P>I then have fields which contain reward payments. I have columns called LeadTimeReward and LeadTimeMissed.&nbsp;</P> <P>What I want to happen is for my table to show the LeadTimeReward as standard, then, if null, return LeadTimeMissed as value in Red Bold font. Can anyone please help?&nbsp;</P> <P>&nbsp;</P> <P>Thanks!</P> Thu, 11 Aug 2022 15:45:22 GMT https://community.qlik.com/t5/App-Development/If-Isnull/m-p/1967865#M79781 Scott_Data 2022-08-11T15:45:22Z https://community.qlik.com/t5/App-Development/If-Isnull/m-p/1967908#M79784 <P>Assuming there's no aggregation related issues, you could use Coalesce(LeadTimeReward,LeadTimeMissed) as your measure. Your color formula might be if(IsNull(LeadTimeReward),Red()).</P> <P>&nbsp;</P> Thu, 11 Aug 2022 17:14:21 GMT https://community.qlik.com/t5/App-Development/If-Isnull/m-p/1967908#M79784 Or 2022-08-11T17:14:21Z