topic Re: Replace Null values with data from other column in QlikView https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510610#M1135851 <HTML><HEAD></HEAD><BODY><P>Are the values actually NULL, or empty strings? What is your data source?</P><P></P><P>If they are empty then this may work.</P><P></P><P>If(ISNULL(ColumnA) OR ColumnA = '',ColumnB,ColumnA) as ColumnA</P></BODY></HTML> Wed, 23 Oct 2013 11:51:48 GMT marcus_malinow 2013-10-23T11:51:48Z Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510604#M1135844 <HTML><HEAD></HEAD><BODY><P>How can I replace null values from column A with values From column B?</P></BODY></HTML> Wed, 23 Oct 2013 11:22:55 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510604#M1135844 2013-10-23T11:22:55Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510605#M1135846 <HTML><HEAD></HEAD><BODY><P>how about this in your load script?</P><P></P><P>If(ISNULL(ColumnA),ColumnB,ColumnA) as ColumnA</P><P>Marcus</P></BODY></HTML> Wed, 23 Oct 2013 11:25:15 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510605#M1135846 marcus_malinow 2013-10-23T11:25:15Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510606#M1135847 <HTML><HEAD></HEAD><BODY><P>maybe you can suppress the null values so that they are not displyed in the table/chart.</P></BODY></HTML> Wed, 23 Oct 2013 11:29:03 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510606#M1135847 2013-10-23T11:29:03Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510607#M1135848 <HTML><HEAD></HEAD><BODY><P>If it is number then use Alt(ColumnA, ColumnB)</P><P>otherwise you have to use <A href="https://community.qlik.com/qlik-users/26760">Marcus Malinow</A> suggestion.</P></BODY></HTML> Wed, 23 Oct 2013 11:29:10 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510607#M1135848 CELAMBARASAN 2013-10-23T11:29:10Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510608#M1135849 <HTML><HEAD></HEAD><BODY><P>I guess Marcus Malinow's solution will do the trick.</P></BODY></HTML> Wed, 23 Oct 2013 11:33:49 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510608#M1135849 2013-10-23T11:33:49Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510609#M1135850 <HTML><HEAD></HEAD><BODY><P>Sadly it does not work. Its a date. For planning production I have DeliveryDate and ExtendedDeliveryDate. As I need to show how the planned deliveries are performing I need to use ExtendedDeliveryDate if there is one, otherwise I need to use DeliveryDate. I was planning to put data from DeliveryDate into null values of ExtendedDeliveryDate so my charts would be more precise. Any suggestions?</P></BODY></HTML> Wed, 23 Oct 2013 11:37:36 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510609#M1135850 2013-10-23T11:37:36Z Re: Replace Null values with data from other column https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510610#M1135851 <HTML><HEAD></HEAD><BODY><P>Are the values actually NULL, or empty strings? What is your data source?</P><P></P><P>If they are empty then this may work.</P><P></P><P>If(ISNULL(ColumnA) OR ColumnA = '',ColumnB,ColumnA) as ColumnA</P></BODY></HTML> Wed, 23 Oct 2013 11:51:48 GMT https://community.qlik.com/t5/QlikView/Replace-Null-values-with-data-from-other-column/m-p/510610#M1135851 marcus_malinow 2013-10-23T11:51:48Z