https://community.qlik.com/t5/App-Development/NullCount-of-Aggr-table-in-KPI/m-p/1810030#M66004 <P>Hello.<BR /><BR />I have a couple of tables and I want to count how many null entries I have in one column (descTitulo) when combined with another column (CodEmpregado) from another table. I want to display that number on a KPI chart.<BR /><BR />When I try just using NullCount(descTitulo) it returns 0 because there are no null values on Table1 by itself. Table1 (which contains column descTitulo) only has null values when combined with Table2 (which contains column CodEmpregado) in a simple table.<BR /><BR />I know I could join both tables in a single larger one on the Data Load Editor but that's not what I want.<BR /><BR />I'm new to Qlik Sense and I've been studying and I figured I should create a temporary table with the AGGR function as a first step. But I'm pretty lost.<BR />How would I go about doing that?<BR />In the image are the two columns combined in a table. I'd like to count how many null values are in the desTitulo column.<BR /><BR />Any help is appreciated.<BR />Thank you in advance. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 21 Dec 2021 21:56:36 GMT lailarhc 2021-12-21T21:56:36Z https://community.qlik.com/t5/App-Development/NullCount-of-Aggr-table-in-KPI/m-p/1810030#M66004 <P>Hello.<BR /><BR />I have a couple of tables and I want to count how many null entries I have in one column (descTitulo) when combined with another column (CodEmpregado) from another table. I want to display that number on a KPI chart.<BR /><BR />When I try just using NullCount(descTitulo) it returns 0 because there are no null values on Table1 by itself. Table1 (which contains column descTitulo) only has null values when combined with Table2 (which contains column CodEmpregado) in a simple table.<BR /><BR />I know I could join both tables in a single larger one on the Data Load Editor but that's not what I want.<BR /><BR />I'm new to Qlik Sense and I've been studying and I figured I should create a temporary table with the AGGR function as a first step. But I'm pretty lost.<BR />How would I go about doing that?<BR />In the image are the two columns combined in a table. I'd like to count how many null values are in the desTitulo column.<BR /><BR />Any help is appreciated.<BR />Thank you in advance. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Tue, 21 Dec 2021 21:56:36 GMT https://community.qlik.com/t5/App-Development/NullCount-of-Aggr-table-in-KPI/m-p/1810030#M66004 lailarhc 2021-12-21T21:56:36Z