Hello. I'm trying to count table records but don't know how to. I need to know how many records have a valid value (not null and not empty) in Field_1 from Table_1, and they match relation with Table_2, when Field_1 of Table_2 is also a valid value.
I need to know how many records match the relation between Table_1 and Table_2, when there are valid values in field Table_1_Field_1 and field Table_2_Field_1. I have tried with a join of the two tables so I can use the Count function, but memory in my computer is not enough and the application hangs. Anyone knows any other way?
Relation between tables comes from field Key_1 in both tables.
Well, I appreciate all answers, but a join is not usefull for me since the application hangs due to not enough memory. I have decided to create a small datawarehouse in a RDBMS, do all data management and calculations there, and import data as is into Qlikview. That, I think, will be much easier for me.
Well, I appreciate all answers, but a join is not usefull for me since the application hangs due to not enough memory. I have decided to create a small datawarehouse in a RDBMS, do all data management and calculations there, and import data as is into Qlikview. That, I think, will be much easier for me.
