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.
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.
I know I could join both tables in a single larger one on the Data Load Editor but that's not what I want.
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. How would I go about doing that? 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.
