topic QlikSense: How to combine read an incomplete date table into an Expression in App Development https://community.qlik.com/t5/App-Development/QlikSense-How-to-combine-read-an-incomplete-date-table-into-an/m-p/1628519#M46762 <P>Hi all. I'm trying a new solution for a problem I posted <A href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.qlik.com%2Ft5%2FQlik-Sense-App-Development%2FHow-to-Join-with-filling-in-of-missing-values%2Fm-p%2F1628168%23M46733&amp;data=02%7C01%7Cmichael.hoy%40ikea.com%7C60ce1d54a53d4bdc4cfd08d741c29542%7C720b637a655a40cf816af22f40755c2c%7C0%7C0%7C637050176297112764&amp;sdata=Wq%2FQRj5OdcHnO%2F6dbIoYFzRvTCCzjnTS1prrBhCk%2BIQ%3D&amp;reserved=0" target="_self">here</A>. I am now trying instead to combine separate tables in the UI, where one of the tables has an incomplete date set.</P><P>I want to generate the DesiredUITable below, where across the dimensions of Person and MonthEnd, if there is a corresponding FactMonthEnd I get the Fact value, else I get 0 or null.</P><P>My attempt below right is <SPAN><STRONG>if(FactMonthEnd=MonthEnd,Fact)</STRONG>. This generates excess null values on the rows where there is a Fact.</SPAN></P><P>Any suggestions how I can get to the DesiredUITable below? Thanks in advance.</P><TABLE><TBODY><TR><TD>DateTable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>FactTable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>DesiredUITable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Person</TD><TD>MonthEnd</TD><TD>&nbsp;</TD><TD>Person</TD><TD>FactMonthEnd</TD><TD>Fact</TD><TD>&nbsp;</TD><TD>Person</TD><TD>MonthEnd</TD><TD>Desired Expression</TD></TR><TR><TD>1</TD><TD>31.01.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD></TR><TR><TD>1</TD><TD>28.02.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>28.02.2018</TD><TD>0 or null</TD></TR><TR><TD>1</TD><TD>31.03.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD></TR><TR><TD>1</TD><TD>30.04.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.04.2018</TD><TD>0 or null</TD></TR><TR><TD>1</TD><TD>31.05.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD></TR><TR><TD>1</TD><TD>30.06.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.06.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>31.01.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.01.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>28.02.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD></TR><TR><TD>2</TD><TD>31.03.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.03.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>30.04.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD></TR><TR><TD>2</TD><TD>31.05.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.05.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>30.06.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Person</TD><TD>MonthEnd</TD><TD>if(FactMonthEnd=MonthEnd,Fact)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>28.02.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.04.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.06.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.01.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.03.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.05.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>null (unwanted)</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:00:26 GMT MikeH1983 2024-11-16T20:00:26Z QlikSense: How to combine read an incomplete date table into an Expression https://community.qlik.com/t5/App-Development/QlikSense-How-to-combine-read-an-incomplete-date-table-into-an/m-p/1628519#M46762 <P>Hi all. I'm trying a new solution for a problem I posted <A href="https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.qlik.com%2Ft5%2FQlik-Sense-App-Development%2FHow-to-Join-with-filling-in-of-missing-values%2Fm-p%2F1628168%23M46733&amp;data=02%7C01%7Cmichael.hoy%40ikea.com%7C60ce1d54a53d4bdc4cfd08d741c29542%7C720b637a655a40cf816af22f40755c2c%7C0%7C0%7C637050176297112764&amp;sdata=Wq%2FQRj5OdcHnO%2F6dbIoYFzRvTCCzjnTS1prrBhCk%2BIQ%3D&amp;reserved=0" target="_self">here</A>. I am now trying instead to combine separate tables in the UI, where one of the tables has an incomplete date set.</P><P>I want to generate the DesiredUITable below, where across the dimensions of Person and MonthEnd, if there is a corresponding FactMonthEnd I get the Fact value, else I get 0 or null.</P><P>My attempt below right is <SPAN><STRONG>if(FactMonthEnd=MonthEnd,Fact)</STRONG>. This generates excess null values on the rows where there is a Fact.</SPAN></P><P>Any suggestions how I can get to the DesiredUITable below? Thanks in advance.</P><TABLE><TBODY><TR><TD>DateTable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>FactTable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>DesiredUITable:</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>Person</TD><TD>MonthEnd</TD><TD>&nbsp;</TD><TD>Person</TD><TD>FactMonthEnd</TD><TD>Fact</TD><TD>&nbsp;</TD><TD>Person</TD><TD>MonthEnd</TD><TD>Desired Expression</TD></TR><TR><TD>1</TD><TD>31.01.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD></TR><TR><TD>1</TD><TD>28.02.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>28.02.2018</TD><TD>0 or null</TD></TR><TR><TD>1</TD><TD>31.03.2018</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD></TR><TR><TD>1</TD><TD>30.04.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.04.2018</TD><TD>0 or null</TD></TR><TR><TD>1</TD><TD>31.05.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD></TR><TR><TD>1</TD><TD>30.06.2018</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.06.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>31.01.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.01.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>28.02.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD></TR><TR><TD>2</TD><TD>31.03.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.03.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>30.04.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD></TR><TR><TD>2</TD><TD>31.05.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.05.2018</TD><TD>0 or null</TD></TR><TR><TD>2</TD><TD>30.06.2018</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>Person</TD><TD>MonthEnd</TD><TD>if(FactMonthEnd=MonthEnd,Fact)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.01.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>28.02.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.03.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.04.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>40</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>31.05.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>1</TD><TD>30.06.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.01.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>20</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>28.02.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.03.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>20</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.04.2018</TD><TD>null (unwanted)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>31.05.2018</TD><TD>null (desired)</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>10</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>2</TD><TD>30.06.2018</TD><TD>null (unwanted)</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 20:00:26 GMT https://community.qlik.com/t5/App-Development/QlikSense-How-to-combine-read-an-incomplete-date-table-into-an/m-p/1628519#M46762 MikeH1983 2024-11-16T20:00:26Z